The acquisition of Zabbix custom monitoring Windows performance counters
After installing the client, I intend to monitor the performance counters on the sql server side, mainly monitoring the counters related to windows. The online writing is not detailed enough, as a beginner, I still found more information, and finally the test was successful.
First, to find the counter, you can execute it on the command line:
[plain] view plain copy
Typeperf-Q > D:\ counters.txt
You are now ready to monitor the following values:
[plain] view plain copy
\ SQLServer:Buffer Manager\ Buffer cache hit ratio
\ SQLServer:Buffer Manager\ Checkpoint pages/sec
\ SQLServer:Buffer Manager\ Lazy writes/sec
\ SQLServer:Buffer Manager\ Page life expectancy
\ SQLServer:Memory Manager\ Target Server Memory (KB)
\ SQLServer:Memory Manager\ Total Server Memory (KB)
\ Memory\ Available MBytes
