Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  2. ZBX-19861

Template MSSQL by ODBC not work on Istance with large number of DB



    • Problem report
    • Status: Open
    • Trivial
    • Resolution: Unresolved
    • 5.4.2, 5.4.3
    • None
    • Templates (T)


      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: Template out of index => 0 symbol remain.

      The first part of query in this template return a large amount of rows (over 2600, screen: MSSQL query number of row)

      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: Query Template general)

      Mass update for all item on MSSQL Templace with this new template (screen: Use of general template)



      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 (Template DB-log and Template DB-state) and use on Database discovery Item (Use of db template)



      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?



        1. MSSQL query number of row.JPG
          MSSQL query number of row.JPG
          57 kB
        2. Query Template general.JPG
          Query Template general.JPG
          132 kB
        3. Template DB-log.JPG
          Template DB-log.JPG
          61 kB
        4. Template DB-state.JPG
          Template DB-state.JPG
          62 kB
        5. Template new item.JPG
          Template new item.JPG
          44 kB
        6. Template out of index.JPG
          Template out of index.JPG
          93 kB
        7. Use of db template.JPG
          Use of db template.JPG
          160 kB
        8. Use of general template.JPG
          Use of general template.JPG
          239 kB



            zux Edgars Melveris
            davvo84 Andrea
            0 Vote for this issue
            1 Start watching this issue