Documentation forSQL Sentry

SQL Sentry Failsafe Conditions

Introduction

Failsafe Conditions have an assigned default severity and associated tags, and will affect your environment's Environmental Health Score (EHO). Failsafe Conditions fall into the following two categories:

  • Connection Status
  • Error

Instance StatusFailsafe Conditions are met when an instance goes Offline or Online. The Offline condition for an instance is met if a server crashes or becomes unavailable. The Online condition is met once that instance becomes available again. FailsafeErrorConditions are met when there's an error detected in a SQL Sentry monitoring service or related monitoring process.

Note:  The Log to Database action and the Send Email action are configured by default for all Failsafe Conditions. You can be alerted when an instance goes offline, or when the SQL Sentry monitoring service experiences an error and is unable to perform its work.

Configure Actions for Failsafe Conditions

Configure actions in response to Instance Status Failsafe Conditions being met at these levels: shared groups (Global), site, computer group, computer, and instance. Configure actions in response to Failsafe Error Conditions being met at the global level (shared groups) or at the site level. 

To add a Failsafe Condition, complete the following steps:

1. Open the Navigator pane (View > Navigator), and then select the desired node where you want to configure an action.
SQL Sentry Navigator Pane select desired node 

2. Open the Conditions Pane (View > Conditions) and then select Failsafe Conditions from the dropdown menu.

SQL Sentry Conditions Pane elect Failsafe Conditions

3. Select Add in the Conditions pane to open the Actions Selector. Expand the applicable object and condition. Use the checkbox(es) to select which actions should be taken in response to this condition being met, and then select OK.
SQL Sentry Actions Selector Failsafe Conditions

Additional Information: For more information about actions that can be taken when a condition is met, see the Actions topic.

The following is a complete list of all Failsafe Conditions.

Amazon RDS for SQL Server 

Condition Description
Offline Amazon RDS is offline or otherwise inaccessible. 
Online Amazon RDS is online and accessible. 

Analysis Services

Condition Description
Offline Analysis Services is offline or otherwise inaccessible.
Online Analysis Service is online and accessible.

Analytics Platform System 

Condition Description
Offline Analytics Platform System is offline or otherwise inaccessible.
Online Analytics Platform System is online and accessible. 

Azure SQL Data Warehouse 

Condition Description
Offline  Azure SQL Data Warehouse is offline or otherwise inaccessible. 
Online  Azure SQL Data Warehouse is online and accessible. 

Azure SQL Database

Condition Description
Offline Azure SQL Database is offline or otherwise inaccessible. 
Online Azure SQL Database is online and accessible. 

Monitoring Service

Note:  Depending on your product version, the condition names and descriptions may reference SQL Sentry or SentryOne for the monitoring service and database.
Condition Description
Device Connection Status Monitor: Error An error was encountered by the Device Connection Status Monitor, the process responsible for monitoring device connections.
Event History Monitor: Error An error was encountered by the Event History Monitor, the process responsible for historical data collection from various sources.
Job Monitor: Error An error was encountered by the Job Monitor, the process responsible for collecting data for running SQL Server Agent Jobs.
Message Processor: Message Action Throttled The Message Processor reached its max messages per interval threshold, and at least one message was throttled. Subsequent messages are sent to the Actions Log. For more information, see SQL Sentry Monitoring Service > Settings.
Monitoring Service: Action Failed The SQL Sentry Monitoring Service attempted to execute an action, but the action failed. For example, the Send Email Action can fail if the SMTP Server is unavailable.              
Monitoring Service: Performance Collection Failed The Performance Monitor encountered an error while collecting data for a specific performance counter.
Monitoring Service: Repository Error An error occurred while writing data to the SQL Sentry database.
Monitoring Service: Send Heartbeat Error The Monitoring Service encountered a critical error while sending a heartbeat to the SQL Sentry database.
Monitoring Service: SQL Sentry Database Offline The SQL Sentry database is offline or otherwise inaccessible.
Monitoring Service: SQL Sentry Database Online The SQL Sentry database is online and accessible.
Monitoring Service: Synchronization Error The SQL Sentry Monitoring Service encountered a critical error while synchronizing settings from the SQL Sentry database with its configuration management thread.
Performance Analysis Data Writer: Error The Performance Analysis data writer encountered an error
Performance Monitor: Error An error was encountered by the Performance Monitor, the process responsible for collecting performance data.
Reporting Services Monitor: Error An error is encountered by the Reporting Services Monitor, the process responsible for collecting data for SSRS reports.
vCenter Collector: Error The vCenter collector encountered an error.
Windows Task Scheduler Monitor: Error An error was encountered by the Task Scheduler Monitor, the process responsible for collecting data for Windows Tasks.

SQL Server

Note:  Make use of Condition Settings when configuring alerts for conditions. Condition filters are available which can help fine tune exactly when a condition is considered met.
Condition Description
SQL Server Availability Group
Failover
The SQL Availability Group failed over.
SQL Availability Replica Healthy The SQL Availability Replica is healthy.
SQL Availability Replica Unhealthy The SQL Availability Replica is unhealthy.
SQL Server Agent: Offline SQL Server Agent is offline or otherwise inaccessible.
SQL Server Agent: Online SQL Server Agent is online and accessible.
SQL Server Cluster Failover The SQL Server cluster failed over.
SQL Server Instance: Offline SQL Server is offline or otherwise inaccessible.
SQL Server Instance: Online SQL Server is online and accessible.

Trintri VMstore 

Condition Description
Offline Trintri VMstore is offline or otherwise inaccessible. 
Online Trintri VMstore is online and accessible. 

vCenter 

Condition Description
Offline vCenter is offline or otherwise inaccessible. 
Online vCenter is online and accessible.

VMware Host

Condition Description 
Offline VMware host is offline or otherwise inaccessible.
Online VMware host is online and accessible. 

Windows

Condition Description
Offline Windows is offline and other inaccessible. 
Online Windows is online and accessible. 

Windows Instance

Condition Description
Offline Windows instance is offline or otherwise inaccessible.
Online Windows instance is online and accessible.