Schema modified

VN:RO [1.9.17_1161]
Rating: 3.5/5 (2 votes cast)
2
9,480 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

WriteLog wait time

VN:RO [1.9.17_1161]
Rating: 5.0/5 (2 votes cast)
2
21,693 0 ,
During a transaction, data is written to the log cache so that it’s ready to be written to the log file on commit, or can be rolled back if necessary. When the log cache is being flushed to disk, the SQL Server session will wait on the WriteLog wait type. Read more

Buffer cache used per database in MB

VN:RO [1.9.17_1161]
Rating: 4.9/5 (7 votes cast)
7
12,324 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

Table size (MB)

VN:RO [1.9.17_1161]
Rating: 4.4/5 (8 votes cast)
8
25,039 0
This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes. Read more

Server principals with default database offline

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