SQL: PAGE LIFE EXPECTANCY
Page Life Expectancy metric measures the average time in seconds that pages stay in the buffer pool. It is closely…
SQL: CONNECTION RESPONSE TIME
High response times generally occur when sessions are blocked or when either there is heavy network traffic or network problems…
SQL: BUFFER CACHE HIT RATIO
This metric gives the ratio of the data pages found and read from the SQL Server buffer cache and all…
CPU HARDWARE INTERRUPT
Symptoms: Slowness in the Operating System response due to high usage of the CPU by hardware interrupts. Impact: Critical An…
CLOCK SYNC RULE
Symptoms: Two or more database servers (local or cloud-based) report different SQL clock times. Impact: High Recommended action : Examine…
INDIVIDUAL CPU CORE UTILIZATION
A CPU core is a single processing unit within a complete CPU (Central Processing Unit). Modern CPUs typically have multiple…
SQL BATCH REQUEST
Symptoms: Slow SQL responses when a mirrored database is experiencing connection speed problems. Impact: Medium Expected behavior : There is…
AVAILABLE MEMORY % BELOW THRESHOLD
This measure corresponds to a shortage of memory to satisfy all program needs. That means the operating system must flush…
DATABASE INTERNAL BUG
Symptoms: Users report that some function has stopped working. Impact: High Expected behavior : The standard threshold setting for this…
REMOTE DESKTOP ACTIVITY
Metric: Remote Desktop Activity Impact: Informational Description: AimBetter tracks the incidence of users accessing the database through a remote…