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
For a complete explanation and example usage scenarios for each behavior, see the Action Behavior topic.
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:
|Condition Type||Description||Additional Info|
|Inherited Condition||Displays the configured actions that are inherited by the currently selected object.|
|Explicit||Displays the configured actions that are explicitly set at the current object level.|
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:
|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.
Alternatively, unsnooze all snoozed conditions/actions through Tools > Unsnooze All.