Principals with sysadmin login

VN:RO [1.9.17_1161]
Rating: 3.8/5 (5 votes cast)
30,378 0 ,
This metric counts the number of principals who are members of the sysadmin fixed server role. Adding a normal user to this role could pose a security risk and is not recommended. Read more

Untrusted check constraints

VN:RO [1.9.17_1161]
Rating: 4.0/5 (4 votes cast)
11,413 0
This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. This can point to a data integrity issue which should be investigated. Read more

Identity columns near limit

VN:RO [1.9.17_1161]
Rating: 4.6/5 (7 votes cast)
17,036 0
If your application relies on identity columns, use this metric to measure the number of identity columns that are near to the limit per database. Read more

Out of memory errors

VN:RO [1.9.17_1161]
Rating: 5.0/5 (2 votes cast)
10,684 0 , ,
The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of Memory error alert when it gets registered there. Read more

Last backup size

VN:RO [1.9.17_1161]
Rating: 3.7/5 (3 votes cast)
12,920 0
Backups are at the heart of the activities of any DBA. You have to restore the backup to know it is good, but you can get an early alert that something is wrong if your backup size changes rapidly or unexpectedly in a short period of time. Read more

Schema modified

VN:RO [1.9.17_1161]
Rating: 3.5/5 (2 votes cast)
9,850 0 ,
The metric is a necessary step in order to achieve the key purpose of this metric, which is to create an alert that will be raised when something is added to the schema, or the existing schema is modified. Read more