DATABASE MIRROR
Symptoms: Slow SQL responses coming from failure of the database mirroring. Impact: Medium Description: This alert works alongside the alert…
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
Symptoms: Slow SQL responses have degraded, due to CPU core overload. Impact: Medium Description: This alert works together with the…
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
Symptoms: Slow SQL responses coming from fall in available RAM. Available memory (percentage of total) is below the threshold. Impact:…
DATABASE INTERNAL BUG
Symptoms: Users report that some function has stopped working. Impact: High Expected behavior : Standard threshold setting for this…
ALWAYSON NOT SYNCHRONIZED
Symptoms: AlwaysOn now reads as ‘not synchronized’ indicating loss of quorum for the database cluster. The database is no longer…
QUERIES BLOCKED
Symptoms: Users report that some process has stopped or timed-out. Impact: Medium This alert means that some unidentified query has…
SQL DATA GROWTH
Symptoms: Total database size increased and is now larger than the designated threshold. Impact: Medium Rapid increase in database size…
