SQL: DEADLOCK
A deadlock occurs when two or more processes compete for exclusive access to a resource but cannot obtain it because…
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…
DATABASE MIRROR
Symptoms: Slow SQL responses coming from the failure of the database mirroring. Impact: Medium Description: This alert works alongside the…
SERVICE NOT RUNNING
Symptoms: Users report that some dependent application (typically ERP, SAP, Priority, BI, etc.) is not responding. Impact: Critical Description: One…
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…