Monitors for Managed Microsoft SQL Server Service

Updated by Jared Ruckle on Oct 14, 2014
Article Code: kb/953

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

Monitors for Microsoft SQL Database Mirroring

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

Monitors for Microsoft SQL Server Analysis Services

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

Monitors for Microsoft SQL Server Reporting Services

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