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
Tracking Data Decode Service (TDDS) is not running on any host instance when global tracking option is enabled