SQL: DEADLOCK
A deadlock occurs when two or more processes compete for exclusive access to a resource but cannot obtain it because…
SQL: PAGE LIFE EXPECTANCY
Page Life Expectancy metric measures the average time in seconds that pages stay in the buffer pool. It is closely…
SQL: CONNECTION RESPONSE TIME
High response times generally occur when sessions are blocked or when either there is heavy network traffic or network problems…
SQL: BUFFER CACHE HIT RATIO
This metric gives the ratio of the data pages found and read from the SQL Server buffer cache and all…
CPU HARDWARE INTERRUPT
Symptoms: Slowness in the Operating System response due to high usage of the CPU by hardware interrupts. Impact: Critical An…
CLOCK SYNC RULE
Symptoms: Two or more database servers (local or cloud-based) report different SQL clock times. Impact: High Recommended action : Examine…
SQL BATCH REQUEST
Symptoms: Slow SQL responses when a mirrored database is experiencing connection speed problems. Impact: Medium Expected behavior : There is…
AVAILABLE MEMORY % BELOW THRESHOLD
This measure corresponds to a shortage of memory to satisfy all program needs. That means the operating system must flush…
DATABASE INTERNAL BUG
Symptoms: Users report that some function has stopped working. Impact: High Expected behavior : The standard threshold setting for this…
ALWAYSON NOT SYNCHRONIZED
Symptoms: AlwaysOn now reads as ‘not synchronized’ indicating loss of quorum for the database cluster. The database is no longer…