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

    Details

    • Team:
      Team INT
    • Sprint:
      Sprint 67 (Aug 2020)
    • Story Points:
      2

      Description

      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. 

        Attachments

          Activity

            People

            Assignee:
            mchudinov Maxim Chudinov
            Reporter:
            ddevries Danny de Vries
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: