SQL: DEADLOCK
A deadlock occurs when two or more processes compete for exclusive access to a resource…
SQL: PAGE LIFE EXPECTANCY
Page Life Expectancy metric measures the average time in seconds that pages stay in the…
SQL: CONNECTION RESPONSE TIME
High response times generally occur when sessions are blocked or when either there is heavy…
SQL: BUFFER CACHE HIT RATIO
This metric gives the ratio of the data pages found and read from the SQL…
AVAILABLE MEMORY % BELOW THRESHOLD
This measure corresponds to a shortage of memory to satisfy all program needs. That means…
DATABASE INTERNAL BUG
Symptoms: Users report that some function has stopped working. Impact: High Expected behavior : The…