Zabbix customizing Monitoring for Windows performance counters

After the client is installed, it is intended to monitor the performance counters on the Windows side, primarily to monitor SQL Server-related counters. The online writing is not detailed enough, as the first to learn, or to find more information, the final Test success.

The first thing to find is the counter, which can be executed at the command line:

[plain] view plain copy

1. Typeperf-q > D:\counters.txt

Now you are ready to monitor the following values:

[plain] view plain copy

2. \sqlserver:buffer Manager\buffer Cache Hit ratio

4. \sqlserver:buffer Manager\checkpoint pages/sec

6. \sqlserver:buffer Manager\lazy writes/sec

8. \sqlserver:buffer manager\page Life expectancy

10. \sqlserver:memory manager\target Server Memory (KB)

12. \sqlserver:memory manager\total Server Memory (KB)

14. \Memory\Available MBytes

Zabbix customizing Monitoring for Windows performance counters