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 (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 |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for