MSSQL monitoring

[tonyxavierj]

Hi

We have recently installed Zabbix. we are able to montor our MSSQL DB. I am trying to monitor the number of active sessions. tried adding an item, but unable to get the output.

the tsql script is

SELECT COUNT(*)[Active-Users] from [Active Session]

it gives output in MSSQL management studio. but I dont know how to get this output in Zabbix.
tried editing the existing MSSQL performance counters template, but that did not work

[max.]

Hello tony, you can configure the odbc connection to your sql server and perform the query in a database monitor item type.

https://www.zabbix.com/documentation/current/en/manual/config/items/itemtypes/odbc_checks

Regards