SQL Server Monitoring

Monitoring SQL Server: the basic Windows and SQL Server counters to watch, PRTG configuration, and Always On availability group monitoring.

It is important to monitor SQL Server to ensure its proper functioning and the performance of the databases it hosts.


Basic counters

Windows and SQL Server counters to monitor: CPU, disk latency, buffer cache hit ratio, page life expectancy, transactions and batches per second.

Always On: Supervision of Availability Groups

Key counters and metrics to monitor for SQL Server Always On Availability Groups.

Monitoring with PRTG

Configure PRTG to monitor SQL Server with the PerfCounter Custom sensor: counter syntax, units, and computing the buffer cache hit ratio.