-
Problem report
-
Resolution: Fixed
-
Trivial
-
5.0.2
-
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.