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 Management Pack for Microsoft System Center Operations Manager 2007 at 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

Show: