Non-Microsoft loaded modules

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
249 0
This metric returns the number of non-Microsoft modules loaded into the SQL Server address space. Having a lot of modules loaded into the address space can cause performance issues in SQL Server. This metric lets you keep an eye on how many modules you have, other than those created by Microsoft. Thanks to Nicolaas Botes for […] Read more

SQL Server instance restarted

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
321 0
This metric and alert will notify you when a SQL Server instance is restarted for any reason. The value returned by the metric is not useful on its own, and is only used by the alert to detect changes. When the server has not been restarted it will report 0 , and when the server […] Read more

Percentage of blocked connections

VN:RO [1.9.17_1161]
Rating: 5.0/5 (3 votes cast)
3
10,116 0
Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention. Read more

Issues found by sp_Blitz

VN:RO [1.9.17_1161]
Rating: 5.0/5 (4 votes cast)
4
16,457 0
This metric looks for configuration, security, health and performance problems, and reports back with a list of issues for you to look into. Read more

Job overran

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
7,531 0
This metric tells you whether a specific SQL Agent job that runs at exactly the same time every day has overrun its expected duration. Read more

Long-running job

VN:RO [1.9.17_1161]
Rating: 3.7/5 (7 votes cast)
7
13,261 0
This metric returns the longest running instance of the named job in the last hour. By creating multiple custom metrics from this example – one for each job you're interested in – you can specify alert thresholds for each job individually. Read more

Number of queries running

VN:RO [1.9.17_1161]
Rating: 4.2/5 (5 votes cast)
5
5,252 0
This metric counts how many queries are running, and alerts you if the value goes above a defined threshold. Read more

Indexes with excessive writes

VN:RO [1.9.17_1161]
Rating: 3.9/5 (7 votes cast)
7
11,890 0
This metric measures the total number of indexes per database, where the number of writes exceed the number of reads. It provides a general indicator of possible performance factors affecting queries in your database. Read more

Database state

VN:RO [1.9.17_1161]
Rating: 1.0/5 (1 vote cast)
1
4,289 0
This metric tells you whether a database is online, restoring, recovering, recovery pending, suspect, emergency, offline or does not exist on the server. Read more

Cached pages in TempDB (MB)

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
5,787 0 ,
This metric helps a DBA analyze how well TempDB is working on their server. Knowing more about what is stored in it, and by which process, will greatly help diagnose performance issues. Read more