SQL: DEADLOCK
A deadlock occurs when two or more processes compete for exclusive access to a resource but cannot obtain it because…
AVAILABLE MEMORY % BELOW THRESHOLD
This measure corresponds to a shortage of memory to satisfy all program needs. That means the operating system must flush…
QUERIES BLOCKED
Symptoms: Users report that some process has stopped or timed-out. Impact: Medium This alert means that some unidentified query has…
SQL: BLOCK
Background Blocking occurs when one process holds a lock on a specific resource and a second one attempts to acquire…
SQL: LOG GROWTH
Symptoms: Transaction log size has increased faster than the designated threshold rate. Impact: High AimBetter metric uses the predicted log…
SQL: LOG OVER-SIZED
This metric is intended to identify any case where the transaction log file has grown beyond the planned size. The…
SQL: QUERIES RUNNING LONG
Symptoms: Queries are running longer than expected Impact: High Slow SQL responses will degrade the user experience, resulting in poor efficiency…
SQL: EXCEPTIONS
Symptoms: Incorrect coding may cause SQL errors when executing. Impact: Medium SQL Exceptions will interrupt user flow, and potentially may…
TSQL: KILL PROCESS
Metric: Count of processes that have been killed. Impact: Informational AimBetter tracks the number of queries that have been terminated…
SQL: AVERAGE WAIT STATES
Symptoms: Average wait states for running queries is high, indicating poor performance. Impact: Medium AimBetter monitor is reporting on the…