Page History
...
The following table describes what type of metrics are measured, their status, when alerts are raised, their criticality levels, the collection frequency for each metric, and if email alerts are sent.
Metric | Category | Status | Alert raised when/threshold | Collection Interval | Email Alert |
---|---|---|---|---|---|
Instance status | Availability | up down | critical: instance down | Runs every half minute | Yes |
Instance response time | Availability | response time ok slow response time | warning: 2000 ms critical: 5000 ms | Runs every half minute | Yes |
Database status | Availability | normal suspect offline inaccessible emergency mode | critical: suspect, offline, inaccessible, emergency mode |
Runs every day | Yes | |
Database never backed up | Disaster recovery | backed up never backed up |
critical: never backed up |
Runs every day | No | ||||
Database not backed up recently | Disaster recovery | backed up recently in the last 7 days no full backup in 7 days or more no differential backup in 7 days or more | critical: no full backup in 7 days or more warning: no differential backup in 7 days or more | Runs every day | No |
Databases with no CHECKDB integrity check | Disaster recovery | CHECKDB never run | critical: CHECKDB never | Runs every day | No |
Databases with no recent CHECKDB integrity check | Disaster recovery | run CHECKDB in the last 7 days no recent CHECKDB in more than 7 days no recent CHECKDB in more than 30 days | no recent CHECKDB in more than 7 days no recent CHECKDB in more than 30 days | Runs every day | No |
Drives at risk | Storage capacity | below 75 % capacity between 75% and 90% above 90% | warning: between 75% and 90% critical: above 90%, server drive is at risk of being full soon | Runs hourly | Yes |
Databases at risk | Storage capacity | below 75 % capacity between 75% and 90% above 90% | warning: between 75% and 90% critical: above 90% | Runs hourly | Yes |
Database Auto shrink enabled | Configuration check | enabled disabled | warning: enabled | Runs every day | No |
Instance xp_cmdshell enabled | Configuration check | enabled disabled | critical: enabled | Runs every day | No |
Database Tempdb files not all the same size | Configuration check | same size not the same size | warning: not the same size | Runs every day | No |
Info | ||
---|---|---|
| ||
IDERA SQL Inventory Manager allows you to refresh these metrics at any time from the instance view. For more information about this option, please refer to Viewing instance information. |
...
For more term definitions, refer to Definition of terms.
Excerpt |
---|
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |
...
...