What We Monitor

The table below outlines the items that the SQLRDS service monitors.

SQLRDS Monitored Item

Monitored Item Included

Automated Alert Monitoring

Database space threshold checks.

MC900432530[1]

Transaction log space threshold checks

MC900432530[1]

Database and transaction log Full alerting

MC900432530[1]

Database status checks

MC900432530[1]

Database configuration checks

MC900432530[1]

SQL Agent job failure checks

MC900432530[1]

SQL Agent long running job checks

MC900432530[1]

SQL Server, SQL Agent, SSRS, SSAS, FullText service failure checks

MC900432530[1]

Server heartbeat failure alerting

MC900432530[1]

SQL blocking locks alerting

MC900432530[1]

Server disk space usage alerting

MC900432530[1]

High severity event alerting

MC900432530[1]

Recent full database and transaction log backup check

MC900432530[1]

SQL Server cluster event checks

MC900432530[1]

Log Shipping failure alerting
(if Log shipping implemented)

MC900432530[1]

Database Mirroring failure alerting
(if Database Mirroring implement)

MC900432530[1]

Replication failure alerting
(if Replication is implemented)

MC900432530[1]

Always ON Availability Group alerting
(if Database Always ON AG is implemented)

MC900432530[1]

Server Performance Counters threshold checks and alerting. CPU, Network, Memory, Disk and SQL Server utilisation.

MC900432530[1]

Alert Escalation Notifications (SQLRDS Plus/Plus24 only)

MC900432530[1]

Alerts via Email and SMS

MC900432530[1]

Acknowledge Alerts via Email, SMS or Web Portal

MC900432530[1]

Data Collection and Reporting

Server and SQL Server Performance Counters Data Collection for Reporting and Capacity Planning (every 5 minutes)

MC900432530[1]

SQL Server 2012 Performance Dashboard installed

MC900432530[1]

Database growth data collection

MC900432530[1]

Wait Statistics Collection

MC900432530[1]

Web Console to view System status, alerts, performance and current issues

MC900432530[1]

Weekly SQL Server Alert and Issue Standard Reports

MC900432530[1]

SQL Server Health Overview Dashboard

MC900432530[1]

SQL Server Issue Overview Dashboard

MC900432530[1]

Extended Monitoring (Extra Charges Apply)

VMWare host monitoring
Correlate SQL VM and VMWare Host issues

MC900432530[1]

Monitor Non SQL Servers

MC900432530[1]

Monitor Network Devices

MC900432530[1]

Monitor Storage Systems

MC900432530[1]