Zabbix monitoring SQL databases on 1300 servers

[Stephen J Capita]

I am in the process of migrating all our alerting from a very old product called server vantage to zabbix. I have most things moved over, but looking at some custom alerting we had for sql databases. I have found this user created script which would be ideal. But just need help getting it setup. It mentions a powershell script but I see no information on it. Here is the template in question.

https://share.zabbix.com/templates/d...very-lld/#body

When I import it I see I need to set the macro with the sql instance name, but I dont know about the powershell script.

We use an SQL instance name of SQL Server (MSSQLEXP2016) so this is what I have defined in my macro:



This is the discovery key, but it talks about a powershell script. I am not sure where to set this



When I try to add the template to a server, it comes back with unknown metric windowsdb.discovrey.



I am running zabbix 6.0.9 lts on centos 8 stream

[cyber]

I guess you need to add that script to hosts and update it with correct instance name. And then also add UserParameter (UserPArameter=windowsdb.discovery,/path_to_your_ps1_script), which calls that script.

[Stephen J Capita]

Cheers for the help, after further investigation, I found that the counters I needed were perfmon counters. So I am in the process of setting up my own custom template with all the prefmon counters I need.