The following tables detail the monitors supported for the Managed MS SQL service on Lumen Cloud:
Monitors for Microsoft SQL Server Service
Monitor |
Description |
Frequency |
MS-SQL Error Log |
The MS-SQL error Log is polled for errors and failures |
Instant |
Windows Event Log |
The Event log is polled for MS-SQL Server errors |
Instant |
MS-SQL Server Service |
Service The MS-SQL Server Service is not running |
1 Min |
MS-SQL Agent Service |
The MS-SQL Server Agent Service is not running |
1 Min |
MS-SQL SSIS Service |
Alarms if the MS-SQL SSIS Service is not running |
1 Min |
Number of Deadlocks /sec |
Alarms when there is a Deadlock |
15 Min |
MS-SQL Server CPU Usage |
The MS-SQL Server Process is over 90% |
5 Min |
MS-SQL Server Memory Usage |
The MS-SQL Server database engine memory usage is greater than 85% of the total server memory |
5 Min |
Database Unavailable |
Alarms when a database is not online |
5 Min |
Blocking |
Alarms on any SPID is blocked by another SPID or a Full Scan |
10 Min |
Failed SQL Job |
Alarms on any SQL job with a failure status |
15 Min |
Database Last Backed Up |
Alarms when a database has not been backed up in the past 24 hours or more |
15 Min |
Database File Free Space |
Alarms when a databases' data or log files percentage of free space is below X. Only applies to databases that are not set to auto grow. |
15 Min |
Monitor |
Description |
Frequency |
Log Send Queue Size |
Alarms when the Log Send Queue size is above 256MB |
5 Min |
Redo Queue Size |
Alarms when the Redo Queue size is above 256MB |
5 Min |
ACK Latency |
Alarms when the ACK Latency time is above 700 ms |
5 Min |
Mirror Status |
Alarms when a Database Mirror is in an Invalid state |
5 Min |
Monitor |
Description |
Frequency |
MS-SQL OLAP Error Log |
The MS-SQL Analysis Services error Log is polled for errors and failures |
Instant |
MS-SQL OLAP Service State |
The MS-SQL Analysis Services Service is stopped |
1 Min |
MS-SQL OLAP CPU Usage |
The MS-SQL Analysis Services Process is over 90% |
5 Min |
MS-SQL OLAP Memory Usage |
The MS-SQL Analysis Services memory usage is greater than 85% of the total server memory |
5 Min |
MS-SQL OLAP Connection Failures |
Alarms when an application cannot successfully connect to the MS-SQL Analysis Services Service |
5 Min |
MS-SQL OLAP Deadlocks |
Alarms when a deadlock occurs in the OLAP engine |
5 Min |
MS-SQL OLAP I/O Errors |
Alarms when an I/O error is incurred in the OLAP cube |
5 Min |
Monitor |
Description |
Frequency |
MS-SQL SSRS Error Log |
The MS-SQL SSRS error Log is polled for errors and failures |
Instant |
MS-SQL SSRS Service State |
The MS-SQL SSRS Service is stopped |
1 Min |
MS-SQL SSRS CPU Usage |
The MS-SQL SSRS Process is over 90% |
5 Min |
MS-SQL SSRS Memory Usage |
The MS-SQL SSRS memory usage is greater than 85% of the total server memory |
5 Min |
MS-SQL SSRS Errors |
Alarms when an HTTP 400 or 500 Error is thrown |
5 Min |
MS-SQL SSRS Server Busy Errors |
Alarms when an HTTP 503 Error is thrown for insufficient server resources |
5 Min |