Principals with sysadmin login

VN:RO [1.9.17_1161]
Rating: 3.8/5 (5 votes cast)
5
27,359 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

Failed SQL Server logins

VN:RO [1.9.17_1161]
Rating: 4.4/5 (5 votes cast)
5
19,451 0
This metric returns the number of 'login failed' error messages found in the SQL Server error log file in the last hour. Read more

Untrusted check constraints

VN:RO [1.9.17_1161]
Rating: 3.7/5 (3 votes cast)
3
9,189 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: 5.0/5 (5 votes cast)
5
12,967 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)
2
8,753 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)
3
9,555 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

Time since last restore

VN:RO [1.9.17_1161]
Rating: 4.0/5 (1 vote cast)
1
8,052 0
This metric tracks the number of minutes since the most recent restore of the database. Read more

Schema modified

VN:RO [1.9.17_1161]
Rating: 2.0/5 (1 vote cast)
1
7,904 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

Buffer cache used per database in MB

VN:RO [1.9.17_1161]
Rating: 4.9/5 (7 votes cast)
7
10,294 0 ,
Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server. It also helps to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache. Read more