Edit

Monitoring BizTalk Server Databases

  • Article

You can run the Monitor BizTalk Server SQL Agent job to identify any known issues in Management, Message Box, or DTA databases. The job is created when you configure a BizTalk group in BizTalk Server Administration console or upgrade BizTalk from the previous version.

The Monitor BizTalk Server Job

The Monitor BizTalk Server job scans for the following issues in Management, Message Box, and DTA databases:

Note

The Monitor BizTalk Server job only scans for issues. It does not fix the issues found.

  • Messages without any references

  • Messages without reference counts

  • Messages with reference count less than 0

  • Message references without spool rows

  • Message references without instances

  • Instance state without instances

  • Instance subscriptions without corresponding instances

  • Orphaned DTA service instances

  • Orphaned DTA service instance exceptions

  • TDDS is not running on any host instance when global tracking option is enabled

    The Monitor BizTalk Server job is configured and automated to run once in a week. Since the job is computationally intensive, we recommended that you schedule it to run during periods of downtime or low traffic.
    The job fails if it encounters any issues; the error string returned contains the number of issues found. Else, it runs successfully. You can see the details in the job history. If you run the job with Administrator privileges, the error string will be logged to both the job history and the SQL Server Application log.

Important

Failure of this job does not necessarily constitute a critical issue, but rather an issue that should be investigated and addressed as part of regular maintenance of the BizTalk Server databases. This job fails by design in the event it discovers one of the issues listed above.