AimBetter Knowledge Base - Blog

DATABASE MIRROR

Symptoms: Slow SQL responses coming from failure of the database mirroring. Impact: Medium Description: This alert works alongside the alert for Mirror not connected which reports when the connection between the two databases is completely…

Cloud, Clustering, MS-SQL, SQL

September 29, 2020

SERVICE NOT RUNNING

Symptoms: Users report that some dependent application (typically ERP, SAP, Priority, BI, etc.) is not responding. Impact: Critical Description: One or more nominated services that are dependent on the SQL engine (e.g ERP, SAP, Priority,…

September 29, 2020

CLOCK SYNC RULE

Symptoms: Two or more database servers (local or cloud-based) report different SQL clock times. Impact: High Recommended action : Examine the computers that are running with different times, and resolve any issue. Background When two…

Cloud, MS-SQL, SQL

September 29, 2020

INDIVIDUAL CPU CORE UTILIZATION

Symptoms: Slow SQL responses have degraded, due to CPU core overload. Impact: Medium Description: This alert works together with the HOST: CPU CORES UTILIZATION alert which reports average utilization across all cores, by reporting utilization…

MS-SQL, Operating System, SQL

September 29, 2020

DATABASE MIRROR

29 Sep at 2:13 pm

SERVICE NOT RUNNING

29 Sep at 1:49 pm

CLOCK SYNC RULE

29 Sep at 1:38 pm

INDIVIDUAL CPU CORE UTILIZATION

29 Sep at 1:17 pm

SQL BATCH REQUEST

29 Sep at 1:00 pm

AVAILABLE MEMORY % BELOW THRESHOLD

29 Sep at 12:29 pm

DATABASE INTERNAL BUG

29 Sep at 12:11 pm

REMOTE DESKTOP ACTIVITY

29 Sep at 12:06 pm

Cloud Clustering MS-SQL SQL

ALWAYSON NOT SYNCHRONIZED

29 Sep at 11:22 am

Symptoms: AlwaysOn now reads as ‘not synchronized’ indicating loss of quorum for the database cluster. The database is no longer…

Performance Queries SQL

QUERIES BLOCKED

29 Sep at 9:22 am

Symptoms: Users report that some process has stopped or timed-out. Impact: Medium This alert means that some unidentified query has…

Operating System Performance Windows

INTERNET PACKET LOSS

11 Jul at 12:11 pm

Lost packets alert indicates that communications with the internet either get no response or only get a partial response. As…

Operating System Windows

HOST: DISK AVAILABLE SPACE

11 Jul at 11:51 am

Symptoms : Free space ratio on the designated disk has fallen below the threshold. Impact : High Maintaining sufficient storage space…

Performance SQL

MONITORING SQL DATA GROWTH

11 Jan at 12:14 am

Symptoms: Total database size increased and is now larger than the designated threshold. Impact: Medium Rapid increase in database size…

Operating System Performance Windows

HOST: NETWORK UTILIZATION

10 Jan at 10:15 am

Symptoms: Network utilization levels are above threshold Impact: Medium Slow SQL responses will degrade the user experience, resulting in poor…

SQL BATCH REQUEST

29 Sep at 1:00 pm

ALWAYSON NOT SYNCHRONIZED

29 Sep at 11:22 am

Menu