Leveraging the BizTalk monitoring job

A new feature in the BizTalk Server 2010 is a new SQL job that enables you to identify any known issues in the Management, Message Box, or DTA databases. This job and other database jobs are created when you configure a BizTalk group. It scans for issues, but does not fix them for you. The job scans for the following issues in the Management, Message Box, and DTA databases:

  • Messages without any references
  • Messages without reference counts
  • Messages with reference counts less than zero
  • Message references without spool rows
  • Message references without instances
  • Instance states without instances
  • Instance subscriptions without corresponding instances
  • Orphaned DTA service instances
  • Orphaned DTA service instance exceptions ...

Get BizTalk Server 2010 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.