Working with Rules

The following is a summary of rules available out-of-the-box with the SQL Server cartridge. Default threshold values can be changed or scoped to specific values, generally through registry variables. These rules can be copied, modified, disabled, or customized in a wide variety of ways.

This section describes the following rules:


SQL Server Rules

DBSS - Aborted Transactions Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Active Time Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - ADH Service Status

This alarm is invoked when the SQL Server ADH Service is installed but not running.

DBSS - All Active Connections Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Availability Group Database is not Failover Ready

This alarm is invoked when the database is not marked as synchronized in the cluster, and is therefore not ready for a planned manual failover.

DBSS - Availability Group Database is Not Synchronizing

This alarm is invoked when the data synchronization state is NOT SYNCHRONIZING, or if the state is not SYNCHRONIZED for the synchronous-commit group database.

DBSS - Availability Group estimated time for failover (RTO)

This alarm is raised when availability group estimated time for failover (RTO) exceeds a predefined threshold.

DBSS - Availability Group estimated time for failover baseline deviation

This alarm is raised when availability group estimated time for failover (RTO) baseline deviation is detected.

DBSS - Availability Group Listener IP is Not Online

This alarm is invoked when the availability group listener IP is offline, either because it is being brought online or because it failed to be brought online.

DBSS - Availability Group performed a failover

This alarm is invoked when the availability group failed over to one of its secondary replicas.

DBSS - Availability Group potential data loss (RPO)

This alarm is raised when availability group potential data loss (RPO) exceeds a predefined threshold.

DBSS - Availability Group potential data loss baseline deviation

This alarm is raised when availability group potential data loss (RPO) baseline deviation is detected.

DBSS - Availability Group Replica is Disconnected

This alarm is invoked when the availability group replica is disconnected, and is therefore not ready for a failover.

DBSS - Availability Replica is Not Online

This alarm is invoked when the availability replica is unable to read or write from the cluster.

DBSS - Availability Replica is Not Synchronizing

This alarm is invoked when the data synchronization state is NOT SYNCHRONIZING, or if the state is not SYNCHRONIZED for the synchronous-commit database replica.

DBSS - Backup Media Free Space Is Too Low

This alarm is invoked when there is not enough space on the media for the backup.

DBSS - Batch Executions Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Blockers Connections Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Buffer Cache Hit Rate

This alarm is invoked when the buffer cache hit rate falls below a predefined threshold.

DBSS - Buffer Pages Free

This alarm is invoked when the percentage of free buffer pages falls below a predefined threshold.

DBSS - CLR Security

This alarm is invoked when potentially unsafe CLR Assemblies are detected in one of the instance’s databases.

DBSS - CLR Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Cluster Failover

This alarm is invoked when the SQL Server cluster group’s active node has moved from one node to another.

DBSS - Collection Status

This alarm is invoked when Foglight data collection has failed.

DBSS - Connection Time

This alarm is invoked when the average connection time to the instance exceeds a predefined threshold.

DBSS - CPU Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Database Mirroring Queue Loaded Percent

This alarm is invoked when the value of the occupied cache percent parameter exceeds a predefined threshold, indicating data modifications are not being propagated in a timely manner to the Mirroring database.

DBSS - Database Mirroring Role Change

This alarm is invoked upon any modification of the role description at a Principal or Mirror database.

DBSS - Database Mirroring State Changed

This alarm is invoked upon any modification of the mirroring status of the Principal or Mirror database.

DBSS - Database Mirroring Witness State

This alarm is invoked upon any modification of the mirror witness server’s status.

DBSS - Days Since Last Backup

This alarm is invoked when the number of days that have elapsed since the last valid full and differential database backup exceeds a predefined threshold.

DBSS - Days Since Last Backup - No Backup

This alarm is invoked when no valid full backup date is found for a database.

DBSS - Deadlock Details

This alarm is invoked when the SQL Server instance has experienced a deadlock or deadlock chain.

DBSS - Deadlocks

This alarm is invoked when the number of deadlocks encountered by a specific SQL Server instance exceeds a predefined threshold.

DBSS - Deadlocks Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Disk Queue Length

This alarm is invoked when a specific disk has an I/O requests queue length higher than threshold, indicating high competition on disk access.

DBSS - DTC Service Status

This alarm is invoked when the Distributed Transaction Coordinator (DTC) service is installed but not running.

DBSS - Error Log Size

This alarm is invoked when the error log file size exceeds a predefined value, making the log file too large to scan.

DBSS - Executions Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - File Group Utilization

This alarm is invoked when a database data file group is nearing its full capacity.

DBSS - Full Text Search Service

This alarm is invoked when the Full Text Search service (MSSearch) is installed but not running.

DBSS - Hours Since Last Log Backup

This alarm is invoked when the number of hours that have elapsed since the last valid log database backup exceeds a predefined threshold.

DBSS - I/O Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - In Doubt Transactions Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Instance Availability

This alarm is invoked when the SQL Server instance is not running (down) or non-responsive.

DBSS - Integration Service Service Status

This alarm is invoked when the SQL Server Integration Service is installed but not running.

DBSS - Jobs Failed

This alarm is invoked upon detecting a job failure within a SQL Server instance.

DBSS - Jobs Retry

This alarm is invoked when a SQL Server instance job retry is detected.

DBSS - Latch Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Lock Timeout Rate

This alarm is invoked when SQL Server exceeds a predefined threshold of lock timeouts.

DBSS - Lock Timeouts Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Lock Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Log Files Utilization

This alarm is invoked when a database log file is reaching its full capacity.

DBSS - Log Flush Wait Time

This alarm is invoked when the duration of the average log flush for a database exceeds a predefined threshold.

DBSS - Log Shipping Failures Detailed

This alarm is invoked upon encountering log shipping failure.

DBSS - Log Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Long Lock Running

This alarm is invoked when the amount of time for which a specific process in a SQL Server instance has been blocked exceeds a predefined threshold.

DBSS - Long Running Job

This alarm is invoked when a job’s execution time proportionately exceeds average execution time by a given threshold.

DBSS - Long Running Session

This alarm is invoked when a session’s execution time exceeds a predefined threshold (requires PI to be installed and activated).

DBSS - Memory Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Network Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Node Unavailable

This alarm is invoked when at least one node in a cluster is reported as not running (down).

DBSS - Non-Preferred Node

This alarm is raised when Foglight for SQL Server detects that SQL Server is not running on its preferred cluster node.

DBSS - OLAP Services Status

This alarm is invoked when the OLAP service is installed but not running.

DBSS - OS Cluster - Node is Offline

This alarm is invoked when a cluster node is offline, possibly caused by an OS cluster service issue or malfunction at the cluster quorum.

DBSS - Other Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Page Allocations Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Page Life Expectancy

This alarm is invoked when the buffer cache page life expectancy falls below a predefined threshold.

DBSS - Page Splits

This alarm is invoked when the rate per second of page splits per Batch Executions within a SQL Server instance exceeds a predefined threshold.

DBSS - Percentage Free Virtual Memory

This alarm is invoked when the host’s percentage of free virtual memory falls below a predefined threshold.

DBSS - Percentage Recompilations

This alarm is invoked when the compilation rate exceeds a predefined threshold value, indicating either an inadequately small procedure cache or excessive use of dynamic code.

DBSS - Plan Cache Hit Rate

This alarm is invoked when the plan cache hit rate falls below a predefined threshold.

DBSS - Process CPU Utilization

This alarm is invoked when the SQL Server process’s CPU consumption exceeds a predefined threshold.

DBSS - Remote Provider Wait Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Replication Agents - Delivery latency

This alarm is invoked when the delivery latency of a replication agent within a SQL Server instance exceeds a predefined threshold.

DBSS - Replication Agents - Status

This alarm is invoked when a replication agent within a SQL Server instance has a status of ‘Error’, ‘Failed’, or ‘Not Started’.

DBSS - Replication Available

This alarm is invoked upon detecting failures in SQL Server’s replication process.

DBSS - Replication Publications - Due to Expire

This alarm is invoked when the number of hours left until the expiry of a specific publication falls below a predefined threshold.

DBSS - Replication Publications - Errors

This alarm is invoked upon detecting errors in a publication within a SQL Server instance involved in a replication process.

DBSS - Replication Publications - Status

This alarm is invoked upon detecting a publication with the status Failed in a SQL Server instance involved in a Replication process.

DBSS - Replication Subscriptions - status

This alarm is invoked upon detecting the status Failed within a subscription in a SQL Server instance that is involved in a Replication process.

DBSS - Report Server Service Status

This alarm is invoked when the SQL Server Report Service is installed but not running.

DBSS - Resource Pool Usage Too High

This alarm is invoked when the used memory percentage of the resource pool exceeds the predefined threshold.

DBSS - Response Time

This alarm is invoked when the response time exceeds a predefined threshold due to various reasons such as host down, SQL Server down, network issues, or SQL Server overload.

DBSS - Response Time Average Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Retrieve Throughput

This alarm monitors the retrieve throughput of the SQL Server instance.

DBSS - SQL Agent Alerts

This alarm is invoked when the number of SQL Server Agent alerts exceeds a predefined threshold.

DBSS - SQL Agent Error Log Message

This alarm is invoked upon detecting that SQL Server Agent has experienced a new informational error.

DBSS - SQL Agent Error Log Summary

This alarm is invoked upon detecting that SQL Server Agent has experienced new log errors.

DBSS - SQL Browser Service Status

This alarm is invoked when the SQL Server SQL Browser Service is installed but not running.

DBSS - SQL I/O Errors

This alarm fires when I/O errors have been encountered, possibly indicating a need to check the SQL Server log as such errors can result in loss of data.

DBSS - SQL Packets Error Rate

This alarm is invoked when the rate per second of packet errors exceeds a predefined threshold.

DBSS - SQL PI: Change Tracking Error

This alarm is invoked when the change tracking feature, which relies on SQL Server default trace, encounters an error.

DBSS - SQL PI: SQL PI Experiencing Errors

This alarm is invoked when data has not been inserted to the performance repository for more than the predefined threshold (default 30 minutes).

DBSS - SQL Server Agent Status

This alarm is invoked when the SQL Server Agent is installed but not running.

DBSS - SQL Server Error Log Summary

This alarm is invoked upon detecting that SQL Server has experienced new log errors.

DBSS - SQL Server Fatal Current Process Error (severity level 20)

This alarm indicates that a statement has encountered a problem affecting only the current task; the database itself is unlikely to be damaged.

DBSS - SQL Server Fatal Database (dbid) Processes Error (severity level 21)

This alarm indicates that a problem has been encountered that affects all tasks in the current database, but the database itself is unlikely to be damaged.

DBSS - SQL Server Fatal Database Integrity Suspect Error (severity level 23)

This alarm indicates that the integrity of the entire database is in question because of a hardware or software problem.

DBSS - SQL Server Fatal Hardware Error (severity level 24)

This alarm indicates a media failure.

DBSS - SQL Server Fatal Table Integrity Suspect Error (severity level 22)

This alarm indicates that the table or index specified in the message has been damaged by a software or hardware problem.

DBSS - SQL Server Nonfatal Error (severity level lower than 20)

This alarm is invoked upon detecting that SQL Server has experienced new informational error.

DBSS - SQL Writer Service Status

This alarm is invoked when the SQL Server Writer Service is installed but not running.

DBSS - Table Locks

This alarm is invoked when the rate at which a specific SQL Server instance experiences table lock escalations exceeds a predefined threshold.

DBSS - TempDB Out of Storage

This alarm is invoked when creating a temporary table raises an error due to space related issues.

DBSS - Total Connections Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Trans. Lost Time Baseline Deviation

This alarm is invoked when a baseline deviation is detected in this metric in a SQL Server instance.

DBSS - Unable To Check Backup Media

This alarm is invoked when Foglight is unable to read the free space from the backup media due to insufficient permissions, non-existent location, or unsupported OS command.

DBSS - Unavailable

This alarm is invoked when a specific database is not available on a SQL Server instance.

DBSS - Usability Connection Availability

This alarm is invoked when the connection to the SQL Server instance failed.

DBSS - Usability OS Connection Availability

This alarm is invoked when the connection time to the OS exceeds a predefined threshold.

DBSS - Virtualization Overhead too high

This alarm is invoked when the percentage of Virtualization Overhead exceeds a predefined threshold.

DBSS - Worker Thread

This alarm is invoked when the percentage of Worker Threads used exceeds a predefined threshold, indicating SQL Server is overloaded.


SQL Managed Instance Rules

DBSSMI - SQL MI CPU Utilization

This alarm is invoked when SQL Managed Instance CPU consumption exceeds a predefined threshold.

DBSSMI - SQL MI Memory Utilization

This alarm is invoked when SQL Managed Instance Memory consumption exceeds a predefined threshold.

DBSSMI - SQL MI Storage Utilization

This alarm is raised when SQL Managed Instance storage utilization reaches the predefined threshold, which may lead to databases being unable to grow.

DBSSMI - SQL MI TempDB Data Space Utilization

This alarm is raised when SQL Managed Instance TempDB data file utilization reaches the predefined threshold, which may cause operations requiring TempDB to stall or fail.

DBSSMI - SQL MI TempDB Log Space Utilization

This alarm is raised when SQL Managed Instance TempDB log file utilization exceeds predefined threshold, which may cause operations requiring TempDB to stall or fail.


SQL PI Rules

SPI DBSS - PI repository availability

This alarm is invoked when the agent is not working properly and data is not updated in the repository.