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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.