Applies to: SQL Agent Insight version 0.23

Insight Maintenance Mode

Maintenance mode allows an Insight to passively monitor a SQL Server instance without firing alarms (i.e. logging them to the dashboard) or sending e-mail notifications (if configured).

Maintenance mode can be toggled for all metrics at once, for a particular category of metrics, or by the individual metric.

Maintenance mode can be enabled for an Insight using the following methods:

  1. During the connection dialog, prior to opening an Insight by toggling the option Start Insight in Maintenance Mode.
    • Doing so here will enable maintenance mode for all categories within an Insight prior to the first polling of data from the monitored instance.

  2. By toggling the checkbox in the Maintenance column header of the Metrics tab within an Insight.
    • Clicking on the checkbox in the Maintenance column header of an Insight metrics header row will toggle maintenance on or off for all metrics at once.

  3. By right-clicking on the category summary row within an Insight.
    • The category summary row contains the name of the category and the summary of all metric states for that category. Right-clicking on this row within the Insight will toggle only the metrics in that category for maintenance.

  4. By clicking the checkbox for an individual metric in the maintenance column.
■ PRO TIP
Enabling maintenance mode prior to connecting to the SQL Server instance the first time prevents alarms from firing and logging to the dashboard. Additionally, no e-mail notifications (if configured) will be sent for the Insight.
This is highly recommended the first time one monitors a new SQL Server instance to allow for proper threshold configuration. Individual categories can then be taken out of maintenance as deemed necessary per the Insight configuration dialog once thresholds are configured for each individual environment.
■ NOTE
Be sure to click the Save thresholds button. This not only saves the configured thresholds, but will also save the individual maintenance mode for each metric.

An Insight with all categories in maintenance mode indicated by the wrench and screwdriver icon in the row header.
Click to enlarge.
The Insight configuration showing individual metrics in maintenance indicated by the checked checkbox in the Maintenance column as well as the row header being gray in color.
Click to enlarge.