SQL Agent Insights:Documentation:Insight Maintenance Mode

From SQL Agent Insights Wiki

Back to Documentation Main

An Insight with all categories in maintenance mode indicated by the wrench and screwdriver icon in the row header.

Maintenance mode allows an Insight to passively monitor a SQL Server® instance without firing alarms (i.e. logging them) 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:

  • 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.

Error creating thumbnail: Unable to save thumbnail to destination

Enabling maintenance mode prior to connecting to the SQL Server® instance the first time prevents alarms from firing and logging. 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 once thresholds are configured for each individual monitored instance.

  • 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.
An Insight showing individual metrics in maintenance indicated by the checked checkbox in the Maintenance column as well as the row header being gray in color.

  • 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.

  • By clicking the checkbox for an individual metric in the maintenance column.

Error creating thumbnail: Unable to save thumbnail to destination

Be sure to click the Save thresholds button in the Insight action bar. This not only saves the configured thresholds, but will also save the individual maintenance mode for each metric. Additionally the saved thresholds will be loaded automatically for the next monitoring session of this instance.

Back to Documentation Main

Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8