SQL Agent Insights:Documentation:Insight Maintenance Mode

From SQL Agent Insights Wiki
Revision as of 04:45, 8 February 2023 by Wikiadmin (talk | contribs)

Back to Documentation Main


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:


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


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


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



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