SQL Sentry Failsafe Conditions

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 Status Failsafe 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. Failsafe Error Conditions 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 Conditions Pane Add Failsafe Condition
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 

ConditionDescription
OfflineAmazon RDS is offline or otherwise inaccessible. 
OnlineAmazon RDS is online and accessible. 

Analysis Services

ConditionDescription
OfflineAnalysis Services is offline or otherwise inaccessible.
OnlineAnalysis Service is online and accessible.

Analytics Platform System 

ConditionDescription
OfflineAnalytics Platform System is offline or otherwise inaccessible.
OnlineAnalytics Platform System is online and accessible. 

Azure SQL Data Warehouse 

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

Azure SQL Database

ConditionDescription
OfflineAzure SQL Database is offline or otherwise inaccessible. 
OnlineAzure 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.

ConditionDescription
Device Connection Status Monitor: ErrorAn error was encountered by the Device Connection Status Monitor, the process responsible for monitoring device connections.
Event History Monitor: ErrorAn error was encountered by the Event History Monitor, the process responsible for historical data collection from various sources.
Job Monitor: ErrorAn error was encountered by the Job Monitor, the process responsible for collecting data for running SQL Server Agent Jobs.
Message Processor: Message Action ThrottledThe 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 FailedThe 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 FailedThe Performance Monitor encountered an error while collecting data for a specific performance counter.
Monitoring Service: Repository ErrorAn error occurred while writing data to the SQL Sentry database.
Monitoring Service: Send Heartbeat ErrorThe Monitoring Service encountered a critical error while sending a heartbeat to the SQL Sentry database.
Monitoring Service: SQL Sentry Database OfflineThe SQL Sentry database is offline or otherwise inaccessible.
Monitoring Service: SQL Sentry Database OnlineThe SQL Sentry database is online and accessible.
Monitoring Service: Synchronization ErrorThe 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: ErrorThe Performance Analysis data writer encountered an error
Performance Monitor: ErrorAn error was encountered by the Performance Monitor, the process responsible for collecting performance data.
Reporting Services Monitor: ErrorAn error is encountered by the Reporting Services Monitor, the process responsible for collecting data for SSRS reports.
vCenter Collector: ErrorThe vCenter collector encountered an error.
Windows Task Scheduler Monitor: ErrorAn 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.

ConditionDescription
SQL Server Availability Group
Failover
The SQL Availability Group failed over.
SQL Availability Replica HealthyThe SQL Availability Replica is healthy.
SQL Availability Replica UnhealthyThe SQL Availability Replica is unhealthy.
SQL Server Agent: OfflineSQL Server Agent is offline or otherwise inaccessible.
SQL Server Agent: OnlineSQL Server Agent is online and accessible.
SQL Server Cluster FailoverThe SQL Server cluster failed over.
SQL Server Instance: OfflineSQL Server is offline or otherwise inaccessible.
SQL Server Instance: OnlineSQL Server is online and accessible.

Trintri VMstore 

ConditionDescription
OfflineTrintri VMstore is offline or otherwise inaccessible. 
OnlineTrintri VMstore is online and accessible. 

vCenter 

ConditionDescription
OfflinevCenter is offline or otherwise inaccessible. 
OnlinevCenter is online and accessible.

VMware Host

ConditionDescription 
OfflineVMware host is offline or otherwise inaccessible.
OnlineVMware host is online and accessible. 

Windows

ConditionDescription
OfflineWindows is offline and other inaccessible. 
OnlineWindows is online and accessible. 

Windows Instance

ConditionDescription
OfflineWindows instance is offline or otherwise inaccessible.
OnlineWindows instance is online and accessible.