AVAILABLE MEMORY % BELOW THRESHOLD
Symptoms: Slow SQL responses coming from fall in available RAM. Available memory (percentage of total) is below the threshold. Impact:…
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
Symptoms : SQL has detected a block, which may affect other users trying to access the same resource. Impact : Medium…
SQL: LOG GROWTH
Symptoms: Transaction log size has increased faster than the designated threshold rate. Impact: High AimBetter metric uses the predicted log…
SQL: DEADLOCK
Symptoms: SQL hangs temporarily for some users due to deadlock. Impact: Medium As well as delays experienced by users, there…
SQL: LOG OVER-SIZED
Symptoms: Transaction log size relative to database size has grown larger than the threshold ratio Impact: High If uncontrolled, log…
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…
