I have an instance with large number of DB (over 20).
Zabbix MSSQL tamplate can't monitor it because the JSON of "MSSQL: Get performance counters" return over 65555 char and is truncated. Error on screen: => 0 symbol remain.
The first part of query in this template return a large amount of rows (over 2600, screen: )
For temp fix i have cloned this template on 3 template:
Template: MSSQL: Get performance counters General
I have change the inital query (SELECT object_name,counter_name,instance_name,cntr_value FROM sys.dm_os_performance_counters) with query of only used values (screen: )
Mass update for all item on MSSQL Templace with this new template (screen: )
Template MSSQL: Get performance counters DB-state and MSSQL: Get performance counters DB-log
I have use this template for monitoring the single DBs on MSSQL by ODBC: Database discovery
I have split this monitor into 2 template because, with istance over 50 DB and only 1 template, i have another out of bound.
Screen of 2 query template ( and ) and use on Database discovery Item ()
My fix does not work as DBs grow.
A different method is provided to monitor this type of instances or the official template is limited in the number of databases present?