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

Template DB MSSQL by ODBC some triggers never resolve

XMLWordPrintable

    • Sprint 67 (Aug 2020)
    • 2

      The official template 'Template DB MSSQL' contains triggers that will never resolve.

      For example: Rate of log shrinks

      It uses the trigger expression {TEMPLATE_NAME:mssql.db.log_shrinks["

      {#DBNAME}"].min(5m)}>{$MSSQL.LOG_SHRINKS.MAX:"{#DBNAME}

      "}

      The item mssql.db.log_shrinks however measures total shrinks (since SQL server startup). This is a number that will not decrease while the server is running. Therefore, once triggered it will not resolve until SQL server is restarted. There is no conversion to a shrink rate.

      To have a shrink rate trigger there would be some sort of delta to compare against. 

            mchudinov Maxim Chudinov (Inactive)
            ddevries Danny de Vries
            Team INT
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: