Documentation forSQL Sentry

SQL Sentry Conditions Pane

Overview

The Conditions pane is displayed on the right side of the SQL Sentry client by default, and its scope is determined by items selected in the Navigator pane. The Conditions pane is used to configure actions in response to conditions being met as part of the SQL Sentry Alerting and Response System. Actions can be defined in response to certain conditions being met within your environment. Choose from a variety of actions, depending on which condition is being responded to.

All conditions work on the principle of inheritance. This means that if you configure an action in response to a condition being met at the global level (All Targets), it automatically passes down to all applicable objects beneath it. Define global conditions for the most common issues across your environment once and have those passed down to every monitored server automatically. Further refine conditions at each level as needed. For a visual representation of how inheritance works within SQL Sentry, see the alerting and response system hierarchy diagram.

Each condition that you configure in your environment will have an associated behavior. The behavior controls how the condition is carried out relative to any inherited conditions. There are three condition behaviors available:

  • Override inherited actions
  • Combine with inherited actions
  • Disabled

For a complete explanation and example usage scenarios for each behavior, see the Action Behavior topic.

View Menu

The Conditions pane is displayed on the right side of the screen by default. If you don't see the Conditions pane, use the View menu (View > Conditions). Each condition type has an associated actions tab where actions can be configured in response to conditions being met. The following are types of conditions: SQL Sentry Conditions Pane

Condition Type Description Additional Info
Inherited Condition
Displays the configured actions that are inherited by the currently selected object.
  • Configured actions in the Inherited section have a status column that indicates if they apply to the currently selected object.
  • Configured actions with an enabled status have green text.
  • Configured actions with a disabled status are grayed out.

Explicit
Displays the configured actions that are explicitly set at the current object level.
  • An action that is explicitly disabled has red text.
  • Configured actions with an enabled status have green text.

Snoozing a Condition/Action

Conditions/Actions can be snoozed or suppressed for a period of time by right-clicking on the condition/action in the Conditions pane and selecting one of the following options:
Conditions Pane Snooze Alerts Context Menu Options

Snooze Context Menu Option Description
Snooze this Condition/Action Combination
Snoozes the specific condition/action that is selected.
Snooze this Condition for All Actions
Snoozes all instances of the selected condition regardless of the action assigned to it.
Snooze this Action for All Conditions
Snoozes all instances of the selected action regardless of the condition assigned to it.

Additionally, select whether the snooze affects just the hierarchical object that you selected (site, group, target, or instance) or if it affects all objects.

Note:  Conditions that have been snoozed have a gray background in the Conditions pane.

Once a condition/action is snoozed, right-click on the snoozed object and select Unsnooze to unsnooze the object. 

Conditions Pane Unsooze Alerts

Alternatively, unsnooze all snoozed conditions/actions through Tools > Unsnooze All.

SQL Sentry Tools Unsnooze All menu option