Hi All,
I am facing an issue with the template provided by zabbix for monitoring the Sql Server 2012 databases and instances.
Below link I am following to configure the same:
With the above template and configuration I get only the database status, port status. I am expecting to gather the information on database size, log file size, transaction per second statistics, number of users connected, SQL Agent, SQL Browser status.
I think my Unix ODBC connection is working fine as I am able to run the perf_counter queries from linux command prompt and getting expected result there.
[root@ServerName]# zabbix_get -s IP -k perf_counter["\SQLServer
atabases(DB_Name)\Log File(s) Size (KB)"]
1016.000000
And
[root@ServerNAme]# zabbix_get -s IP -k perf_counter["\SQLServeratabases(_Total)\Log File(s) Size (KB)"]
5249544.000000
Appreciate your help guys.
Thanks.
Regards,
Sandeep
I am facing an issue with the template provided by zabbix for monitoring the Sql Server 2012 databases and instances.
Below link I am following to configure the same:
With the above template and configuration I get only the database status, port status. I am expecting to gather the information on database size, log file size, transaction per second statistics, number of users connected, SQL Agent, SQL Browser status.
I think my Unix ODBC connection is working fine as I am able to run the perf_counter queries from linux command prompt and getting expected result there.
[root@ServerName]# zabbix_get -s IP -k perf_counter["\SQLServer
atabases(DB_Name)\Log File(s) Size (KB)"]1016.000000
And
[root@ServerNAme]# zabbix_get -s IP -k perf_counter["\SQLServer
atabases(_Total)\Log File(s) Size (KB)"]5249544.000000
Appreciate your help guys.
Thanks.
Regards,
Sandeep