MS-SQLQueriesSQLSQL: QUERIES OPEN TRANSACTION10 Aug 2023Transactions are committed by SQL when successful or rolled back when not (if they encounter…
MS-SQLQueriesSQLSQL: BLOCKING QUERIES9 Aug 2023A blocking query is a database query that causes other queries or transactions to wait…
MS-SQLQueriesSQLSQL: LONG RUNNING QUERIES25 Jul 2023A SQL Server long-running query refers to a query that is taking a significant amount…
MS-SQLQueriesSQLSQL: DEADLOCK9 Mar 2023A deadlock occurs when two or more processes compete for exclusive access to a resource…
MS-SQLPerformanceQueriesSQLAVAILABLE MEMORY % BELOW THRESHOLD29 Sep 2020This measure corresponds to a shortage of memory to satisfy all program needs. That means…
MS-SQLQueriesSQLSQL: LOG OVER-SIZED9 Jan 2020This metric is intended to identify any case where the transaction log file has grown…
MS-SQLPerformanceQueriesSQLSQL: AVERAGE WAIT STATES25 Dec 2019Symptoms: Average wait states for running queries is high, indicating poor performance. Impact: Medium AimBetter…
MS-SQLQueriesSQLSQL: MIRROR NOT CONNECTED25 Dec 2019Indicator: Connection between a primary SQL database and its mirror database has been lost Impact: Medium…