MSSQL performance counters monitoring

[kerem.yarali]

Hello

I want to monitor MSSQL performance counters. I searched and found some template solutions for this action.

I want to monitor performance counters via perf_counter. I did some research and I found some example which you can find below.

zabbix_agentd -t perf_counter["\SQLServer:General Statistics\User Connections"] . The command returned 0 to me.

I want to ask, I'm not sure if I typed command right. Should I add SQLServer name or some extra things to the perf_counter command ?

Thanks
Kerem

[mfaria]

Hi

Have you tried "typeperf -qx" to see a list all the perf counters availables in Windows? Maybe it helps you.

Marcelo

[Grzegorz Wiktorowski]

In perf_counter["\SQLServer:General Statistics\User Connections"] should be not SQLServer but the real name of MS SQL instance.