Edit

Monitoring SQL Servers

  • Article

Use SQL management pack

The Microsoft SQL Server management pack provides both proactive and reactive monitoring of SQL Server in an enterprise environment. Availability and configuration monitoring, performance data collection, and default thresholds are built for enterprise-level monitoring. Both local and remote connectivity checks help ensure database availability.

With the embedded expertise in the SQL Server management pack, you can proactively manage SQL Server, and identify issues before they become critical. This management pack increases the security, availability, and performance of your SQL Server infrastructure.

The Microsoft SQL Server management pack guide that comes with the pack describes the content of the management pack, and describes how to deploy it. Features of the management pack include:

  • Monitoring the state of the included services such as SQL Server, SQL Agent, Report Server, Notification Services

  • Monitoring the state of databases

  • Monitoring the available space in databases, configurable by % or MB

  • Ensuring databases are configured correctly

  • Ensure clients can connect to the SQL Server

  • Monitor blocked processes

  • Watch for failed agent jobs, and jobs taking an excessive time to execute

  • Monitor the health of replication and alert on failures

  • Monitor the state of Database Mirroring

Next steps