Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 (https://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 |