description | title | ms.custom | ms.date | ms.service | ms.reviewer | ms.suite | ms.topic |
---|---|---|---|---|---|---|---|
Learn more about: Checklist: Monitoring SQL Servers |
Checklist: Monitoring SQL Servers |
06/08/2017 |
biztalk-server |
article |
This topic describes the steps that should be followed to monitor [!INCLUDEbtsSQLServerNoVersion] in a production [!INCLUDEbtsBizTalkServerNoVersion] environment.
Task | Reference |
---|---|
Install the Microsoft [!INCLUDEbtsSQLServerNoVersion] Management Pack for Operations Manager 2007 | SQL Server Monitoring Management Pack (https://go.microsoft.com/fwlink/?linkid=109858) |
Designate the [!INCLUDEbtsSQLServerNoVersion] 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 |