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…
Operating SystemPerformanceWindowsSQL: PAGE LIFE EXPECTANCY6 Mar at 2:09 pmPage Life Expectancy metric measures the average time in seconds that pages stay in the buffer pool. It is closely…
MS-SQLPerformanceSQLSQL: CONNECTION RESPONSE TIME6 Mar at 11:28 amHigh response times generally occur when sessions are blocked or when either there is heavy network traffic or network problems…
MS-SQLPerformanceSQLSQL: BUFFER CACHE HIT RATIO22 Feb at 12:37 pmThis metric gives the ratio of the data pages found and read from the SQL Server buffer cache and all…
Operating SystemPerformanceCPU HARDWARE INTERRUPT13 Feb at 7:49 amSymptoms: Slowness in the Operating System response due to high usage of the CPU by hardware interrupts. Impact: Critical An…
CloudMS-SQLSQLCLOCK SYNC RULE29 Sep 2020Symptoms: Two or more database servers (local or cloud-based) report different SQL clock times. Impact: High Recommended action : Examine…
ClusteringMS-SQLPerformanceSQLSQL BATCH REQUEST29 Sep 2020Symptoms: Slow SQL responses when a mirrored database is experiencing connection speed problems. Impact: Medium Expected behavior : There is…
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…
MS-SQLSQLDATABASE INTERNAL BUG29 Sep 2020Symptoms: Users report that some function has stopped working. Impact: High Expected behavior : The standard threshold setting for this…
CloudClusteringMS-SQLSQLALWAYSON NOT SYNCHRONIZED29 Sep 2020Symptoms: AlwaysOn now reads as ‘not synchronized’ indicating loss of quorum for the database cluster. The database is no longer…