Checklist: Monitoring SQL Servers

This topic describes the steps that should be followed to monitor SQL Server in a production BizTalk Server environment.

Task Reference
Install the Microsoft SQL Server Management Pack for Operations Manager 2007 SQL Server Monitoring Management Pack (http://go.microsoft.com/fwlink/?linkid=109858)
Designate the SQL Server databases as critical in the SQL Server Management Pack. How to Mark BizTalk Server Databases for Customized Monitoring
Ensure that the SQL server machines are monitored. Monitoring SQL Server Agent Jobs and Databases
Ensure that the BizTalk SQL Agent jobs are monitored. Monitoring SQL Server Agent Jobs and Databases