MS-SQLQueriesSQLSQL: DEADLOCK9 Mar at 8:54 amA deadlock occurs when two or more processes compete for exclusive access to a resource but cannot obtain it because…
MS-SQLPerformanceQueriesSQLAVAILABLE MEMORY % BELOW THRESHOLD29 Sep 2020This measure corresponds to a shortage of memory to satisfy all program needs. That means the operating system must flush…
PerformanceQueriesSQLQUERIES BLOCKED29 Sep 2020Symptoms: Users report that some process has stopped or timed-out. Impact: Medium This alert means that some unidentified query has…
MS-SQLQueriesSQLSQL: BLOCK10 Jan 2020Background Blocking occurs when one process holds a lock on a specific resource and a second one attempts to acquire…
MS-SQLQueriesSQLSQL: LOG GROWTH9 Jan 2020Symptoms: Transaction log size has increased faster than the designated threshold rate. Impact: High AimBetter metric uses the predicted log…
MS-SQLQueriesSQLSQL: LOG OVER-SIZED9 Jan 2020This metric is intended to identify any case where the transaction log file has grown beyond the planned size. The…
MS-SQLQueriesSQLSQL: QUERIES RUNNING LONG9 Jan 2020Symptoms: Queries are running longer than expected Impact: High Slow SQL responses will degrade the user experience, resulting in poor efficiency…
MS-SQLQueriesSQLSQL: EXCEPTIONS26 Dec 2019Symptoms: Incorrect coding may cause SQL errors when executing. Impact: Medium SQL Exceptions will interrupt user flow, and potentially may…
MS-SQLQueriesSQLTSQL: KILL PROCESS25 Dec 2019Metric: Count of processes that have been killed. Impact: Informational AimBetter tracks the number of queries that have been terminated…
MS-SQLPerformanceQueriesSQLSQL: AVERAGE WAIT STATES25 Dec 2019Symptoms: Average wait states for running queries is high, indicating poor performance. Impact: Medium AimBetter monitor is reporting on the…