Issues found by sp_Blitz

VN:RO [1.9.17_1161]
Rating: 4.6/5 (8 votes cast)
23,334 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)
11,486 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.8/5 (10 votes cast)
21,689 1
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 (6 votes cast)
9,349 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)
17,607 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: 3.0/5 (2 votes cast)
8,443 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: 3.5/5 (2 votes cast)
10,757 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


VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
7,708 0
CXPACKET waits may or may not be an issue for a system, but on an OLTP style system, they can indicate costly queries that are executing and requiring parallelized plans. Read more

Plan cache hit ratio

VN:RO [1.9.17_1161]
Rating: 4.6/5 (5 votes cast)
17,943 0
A high plan cache hit ratio does not guarantee that all queries are using the cache as well as they might. Knowing the percentage of queries that are satisfied from cache helps you to better understand the plan cache hit ratio value. Read more

Plan cache reuse

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
6,204 0
This metric shows the percentage of cached plans that are being used more than once. If a plan is cached but never reused, there may be an opportunity to tune your server to work more effectively. Read more