Monitoring MSSQLSCOM PerfCounters
Hello all,
I've recently trying to monitor our SCOM SQL Server without success.
When I try to collect a perf_counter:
perf_counter[\MSSQL\$SCCM:Memory Manager\Total Server Memory (KB)]
I get the following in my log: The specified object was not found on the computer.
Testing via zabbix_get I get the correct value: 735726.000000
When trying via zabbix_agentd from the command line:
[Invalid performance counter format.]
Exporting the perfcounters in the server its name is displayed as \MSSQL$SCOM:Memory Manager\Total Server Memory (KB).
However, when i collect it via zabbix_agentd it returns 0 which is incorrect.
I've recently trying to monitor our SCOM SQL Server without success.
When I try to collect a perf_counter:
perf_counter[\MSSQL\$SCCM:Memory Manager\Total Server Memory (KB)]
I get the following in my log: The specified object was not found on the computer.
Testing via zabbix_get I get the correct value: 735726.000000
When trying via zabbix_agentd from the command line:
[Invalid performance counter format.]
Exporting the perfcounters in the server its name is displayed as \MSSQL$SCOM:Memory Manager\Total Server Memory (KB).
However, when i collect it via zabbix_agentd it returns 0 which is incorrect.