diff options
Diffstat (limited to 'templates/db/mssql_odbc/README.md')
| -rw-r--r-- | templates/db/mssql_odbc/README.md | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/templates/db/mssql_odbc/README.md b/templates/db/mssql_odbc/README.md index de907f41cd2..0b6567337f7 100644 --- a/templates/db/mssql_odbc/README.md +++ b/templates/db/mssql_odbc/README.md @@ -233,7 +233,7 @@ There are no template links in this template. |----|-----------|----|----|----| |MSSQL: Service is unavailable |<p>The TCP port of the MS SQL Server service is currently unavailable.</p> |`last(/MSSQL by ODBC/net.tcp.service[tcp,{HOST.CONN},{$MSSQL.PORT}])=0` |DISASTER | | |MSSQL: Version has changed |<p>MSSQL version has changed. Ack to close.</p> |`last(/MSSQL by ODBC/mssql.version,#1)<>last(/MSSQL by ODBC/mssql.version,#2) and length(last(/MSSQL by ODBC/mssql.version))>0` |INFO |<p>Manual close: YES</p> | -|MSSQL: Service has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/MSSQL by ODBC/mssql.uptime)<10m` |INFO |<p>Manual close: YES</p> | +|MSSQL: Service has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/MSSQL by ODBC/mssql.uptime)<10m` |INFO |<p>Manual close: YES</p> | |MSSQL: Failed to fetch info data |<p>Zabbix has not received data for items for the last 30 minutes.</p> |`nodata(/MSSQL by ODBC/mssql.uptime,30m)=1` |INFO |<p>**Depends on**:</p><p>- MSSQL: Service is unavailable</p> | |MSSQL: Too frequently using pointers |<p>Rows with varchar columns can experience expansion when varchar values are updated with a longer string. In the case where the row cannot fit in the existing page, the row migrates and access to the row will traverse a pointer. This only happens on heaps (tables without clustered indexes). Evaluate clustered index for heap tables. In cases where clustered indexes cannot be used, drop non-clustered indexes, build a clustered index to reorg pages and rows, drop the clustered index, then recreate non-clustered indexes.</p> |`last(/MSSQL by ODBC/mssql.forwarded_records_sec.rate) * 100 > 10 * last(/MSSQL by ODBC/mssql.batch_requests_sec.rate)` |WARNING | | |MSSQL: Number of work files created per second is high |<p>Too many work files created per second to store temporary results for hash joins and hash aggregates.</p> |`min(/MSSQL by ODBC/mssql.workfiles_created_sec.rate,5m)>{$MSSQL.WORK_FILES.MAX}` |AVERAGE | | @@ -259,12 +259,12 @@ There are no template links in this template. |MSSQL DB '{#DBNAME}': Number of commits waiting for the log flush is high |<p>Too many commits are waiting for the log flush.</p> |`min(/MSSQL by ODBC/mssql.db.log_flush_waits_sec.rate["{#DBNAME}"],5m)>{$MSSQL.LOG_FLUSH_WAITS.MAX:"{#DBNAME}"}` |WARNING | | |MSSQL DB '{#DBNAME}': Total wait time to flush the log is high |<p>The wait time to flush the log is too long.</p> |`min(/MSSQL by ODBC/mssql.db.log_flush_wait_time["{#DBNAME}"],5m)>{$MSSQL.LOG_FLUSH_WAIT_TIME.MAX:"{#DBNAME}"}` |WARNING | | |MSSQL DB '{#DBNAME}': Percent of log using is high |<p>There's not enough space left in the log.</p> |`min(/MSSQL by ODBC/mssql.db.percent_log_used["{#DBNAME}"],5m)>{$MSSQL.PERCENT_LOG_USED.MAX:"{#DBNAME}"}` |WARNING | | -|MSSQL DB '{#DBNAME}': Diff backup old |<p>The differential backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.diff["{#DBNAME}"])>{$MSSQL.BACKUP_DIFF.CRIT:"{#DBNAME}"}` |HIGH |<p>Manual close: YES</p> | -|MSSQL DB '{#DBNAME}': Diff backup old |<p>The differential backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.diff["{#DBNAME}"])>{$MSSQL.BACKUP_DIFF.WARN:"{#DBNAME}"}` |WARNING |<p>Manual close: YES</p><p>**Depends on**:</p><p>- MSSQL DB '{#DBNAME}': Diff backup old</p> | -|MSSQL DB '{#DBNAME}': Full backup old |<p>The full backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.full["{#DBNAME}"])>{$MSSQL.BACKUP_FULL.CRIT:"{#DBNAME}"}` |HIGH |<p>Manual close: YES</p> | -|MSSQL DB '{#DBNAME}': Full backup old |<p>The full backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.full["{#DBNAME}"])>{$MSSQL.BACKUP_FULL.WARN:"{#DBNAME}"}` |WARNING |<p>Manual close: YES</p><p>**Depends on**:</p><p>- MSSQL DB '{#DBNAME}': Full backup old</p> | -|MSSQL DB '{#DBNAME}': Log backup old |<p>The log backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.log["{#DBNAME}"])>{$MSSQL.BACKUP_LOG.CRIT:"{#DBNAME}"}` |HIGH |<p>Manual close: YES</p> | -|MSSQL DB '{#DBNAME}': Log backup old |<p>The log backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.log["{#DBNAME}"])>{$MSSQL.BACKUP_LOG.WARN:"{#DBNAME}"}` |WARNING |<p>Manual close: YES</p><p>**Depends on**:</p><p>- MSSQL DB '{#DBNAME}': Log backup old</p> | +|MSSQL DB '{#DBNAME}': Diff backup is old |<p>The differential backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.diff["{#DBNAME}"])>{$MSSQL.BACKUP_DIFF.CRIT:"{#DBNAME}"}` |HIGH |<p>Manual close: YES</p> | +|MSSQL DB '{#DBNAME}': Diff backup is old |<p>The differential backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.diff["{#DBNAME}"])>{$MSSQL.BACKUP_DIFF.WARN:"{#DBNAME}"}` |WARNING |<p>Manual close: YES</p><p>**Depends on**:</p><p>- MSSQL DB '{#DBNAME}': Diff backup is old</p> | +|MSSQL DB '{#DBNAME}': Full backup is old |<p>The full backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.full["{#DBNAME}"])>{$MSSQL.BACKUP_FULL.CRIT:"{#DBNAME}"}` |HIGH |<p>Manual close: YES</p> | +|MSSQL DB '{#DBNAME}': Full backup is old |<p>The full backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.full["{#DBNAME}"])>{$MSSQL.BACKUP_FULL.WARN:"{#DBNAME}"}` |WARNING |<p>Manual close: YES</p><p>**Depends on**:</p><p>- MSSQL DB '{#DBNAME}': Full backup is old</p> | +|MSSQL DB '{#DBNAME}': Log backup is old |<p>The log backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.log["{#DBNAME}"])>{$MSSQL.BACKUP_LOG.CRIT:"{#DBNAME}"}` |HIGH |<p>Manual close: YES</p> | +|MSSQL DB '{#DBNAME}': Log backup is old |<p>The log backup has not been executed for a long time.</p> |`last(/MSSQL by ODBC/mssql.backup.log["{#DBNAME}"])>{$MSSQL.BACKUP_LOG.WARN:"{#DBNAME}"}` |WARNING |<p>Manual close: YES</p><p>**Depends on**:</p><p>- MSSQL DB '{#DBNAME}': Log backup is old</p> | |MSSQL AG '{#GROUP_NAME}': Primary replica recovery health in progress |<p>The primary replica is in the synchronization process.</p> |`last(/MSSQL by ODBC/mssql.primary_recovery_health["{#GROUP_NAME}"])=0` |WARNING | | |MSSQL AG '{#GROUP_NAME}': Secondary replica recovery health in progress |<p>The secondary replica is in the synchronization process.</p> |`last(/MSSQL by ODBC/mssql.secondary_recovery_health["{#GROUP_NAME}"])=0` |WARNING | | |MSSQL AG '{#GROUP_NAME}': All replicas unhealthy |<p>None of the availability replicas have a healthy synchronization.</p> |`last(/MSSQL by ODBC/mssql.synchronization_health["{#GROUP_NAME}"])=0` |DISASTER | | |