1 / 31

Proactivity in BizTalk?

Proactivity in BizTalk?. Tord Glad Nordahl. Who am I?. BizTalk Administrator Expert Training Health Checking Debugger Speaker Active contributor at TechNet Active blogger www.biztalkadmin.com. Profile. Profile. Proactivity in BizTalk. What is meant by proactivity How can you know

rafi
Télécharger la présentation

Proactivity in BizTalk?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Proactivity in BizTalk? Tord Glad Nordahl Proactivity - All environments are unique

  2. Who am I? • BizTalk Administrator Expert • Training • Health Checking • Debugger • Speaker • Active contributor at TechNet • Active blogger www.biztalkadmin.com Profile Profile Proactivity - All environments are unique

  3. Proactivity in BizTalk • What is meant by proactivity • How can you know • Where do you look • And how do you prevent it? Proactivity - All environments are unique

  4. Make and keep it stable • Monitoring tools • SCOM • BizTalk 360 • Messagebox Viewer • BizTalk Best Practice Analyzer • Microsoft Baseline Analyzer Proactivity - All environments are unique

  5. Nothing beats your knowledge! BizTalk SQL SQL Agents Performance counters Databases Event log Disks SQL Queries • Performance Counters • PAL • Statistics • Disk space • Throttling • Thresholds • Event log • Known bugs • Infrastructure Proactivity - All environments are unique

  6. How long does it take? • Backup BizTalk Server • CleanupBTFExpiredEntriesJob_BizTalkMgmtDb • MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb • MessageBox_Message_Cleanup_BizTalkMsgBoxDb • MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb • MessageBox_Parts_Cleanup_BizTalkMsgBoxDb • MessageBox_UpdateStats_BizTalkMsgBoxDb • Monitor BizTalk Server • Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb • PurgeSubscriptionsJob_BizTalkMsgBoxDb • Rules_Database_Cleanup_BizTalkRuleEngineDb • TrackedMessages_Copy_BizTalkMsgBoxDb • DTA Purge and Archive Proactivity - All environments are unique

  7. Performance counters • Needs to be monitored over time • Difference between BizTalk related and SQL • Provides you with live and old data Proactivity - All environments are unique

  8. Most important databases • BizTalkMsgBoxDb • BizTalkDTADb • BizTalkMgmtDb • SSODB Proactivity - All environments are unique

  9. BizTalkMsgBoxDb • Spool • TrackingData_x_x • Instances • Marklog • X-RefcountLog Proactivity - All environments are unique

  10. BizTalkDTADb • DebugTrace • MessageInOutEvents • ServiceInstances • Marklog Proactivity - All environments are unique

  11. SQL queries and deadlocks • Make sure you avoid deadlocks • Performance monitor • SQL Profiler Proactivity - All environments are unique

  12. Disks • If your using it, make it fast • Check for I\O issues • Never go below 15% free disk space Proactivity - All environments are unique

  13. Tip: To see all counters at least one host must be running! BizTalk Performance counters Proactivity - All environments are unique

  14. Performance Counter • BizTalk: Message Agent • Active Instance Count • Database sessions • Database session threshold • Database size • High database session • High database size • High in-process message count • High message delivery rate • High message publishing rate • High Process memory • High System memory • High thread count • In-process message count • In-process message count threshold • Message delivery delay (ms)

  15. Performance Counter • BizTalk: Message Agent • Message delivery incoming rate • Message delivery outgoing rate • Message delivery throttling state • Message delivery throttling state duration • Message delivery throttling user override • Message publishing delay (ms) • Message publishing incoming rate • Message publishing outgoing rate • Message publishing throttling state • Message publishing throttling state duration • Message publishing throttling user override • Physical memory usage (MB) • Process memory usage (MB) • Service Class ID • Thread count

  16. Performance Counter • BizTalk: Message Agent • Thread count threshold • Total batches omitted • Total message delivered • Total messages published

  17. Performance Counters • BizTalk: Message Box: General counters • Instances (total number) • MsgBox Dead processes cleanup (purge job) • MsgBoxMsg Cleanup (purge job) • MsgBox Parts Cleanup (purge job) • MsgBox Purge Subscriptions job (purge job) • Spool size • Tracked msg body (purge job) • Tracking data size • Tracking spool cleanup

  18. Performance Counters • BizTalk: Message Box: Host counters • Host queue – Instance state msg refs – length • Host queue – length • Host queue – number of instances • Host queue – suspended messages - lengthr

  19. Performance Counters • BizTalk: TDDS • Batches being processed • Batches committed • Events being processed • Events committed • Records being processed • Records committed • Total batches • Total events • Total failed batches • Total failed events • Total records

  20. Performance counters • BizTalk:Messaging • Active Receive Location • Active Receive Threads • Active Send Messages • Active Send Threads • Documents processed (per second) • Documents received (per second) • Documents resubmitted (per second) • Documents suspended • Documents transmitted/batch • ID Process • Pending Receive Batches • Pending transmitted messages • Request/response timeouts • Throttled receive batches

  21. Performance Counters • BizTalk:Messaging Latency • Inbound Latency (sec) • Outbound Adapter Latency (sec) • Outbound Latency (sec) • Request-Response Latency (sec)

  22. Performance counters • BizTalk:<adapterName>_Receive / Send adapter • Bytes Received • Bytes Received per second • Deleted retries • Lock failures • Lock failures per second • Message received • Messages received per second • Time to build batch

  23. Throttling • Good or bad? • Thresholds met • Performance stalls! Proactivity - All environments are unique

  24. Thresholds • Add more resources and change limits • Remove resources and limit the application Proactivity - All environments are unique

  25. BizTalk Host throttling

  26. BizTalk Host throttling

  27. BizTalk Host throttling Proactivity - All environments are unique

  28. Event log • Look for errors • Monitor and trigger on errors • Keep it clean Proactivity - All environments are unique

  29. Known bugs • You should be aware of all known bugs • CU updates • WCF-SQL, Oracle Custom thread issue on receive • 5649 event ID • etc Proactivity - All environments are unique

  30. Infrastructure Have some idea of your infrastructure: • Virtualization how and where • Locations • Connections and people Proactivity - All environments are unique

  31. Questions? ? Proactivity - All environments are unique

More Related