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
Category: Auditing
Out of memory errors
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
Ad hoc queries running once
This metric measures the total number of ad hoc queries in the plan cache that have only run one time. Read more
Last backup size
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
This metric tracks the number of minutes since the most recent restore of the database. Read more
Schema modified
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
Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server, and also to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache. Read more
Server principals with default database offline
This metric monitors whether a server principal’s default database is offline. When you create a SQL Server server principal (formerly referred to as a server login) it has a default database setting that is used to assist in a connection request when no database is specified. Read more