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. | |
|
Ensure that the BizTalk SQL Agent jobs are monitored. |
