SQL Agent Insights:Documentation:Insight Thresholds: Difference between revisions

From SQL Agent Insights Wiki
(Created page with "Back to Documentation Main <hr> The underlying principle of SQL Agent Insight is the ability to set thresholds for metrics and be notified when these boundaries are breached, via email and/or desktop notifications. This is why it is of utmost importance to set these limits upon the first monitoring of a SQL Server instance. file: insight.png|thumb|right|A typical Insight showing expanded MS DB and Jobs categories along with their p...")
 
No edit summary
Line 9: Line 9:


It is important to have the Insight in either a manual or paused state to prevent a poll midway through an editing cycle which could potentially fire an alarm, and therefore could inadvertently send an unwanted email.
It is important to have the Insight in either a manual or paused state to prevent a poll midway through an editing cycle which could potentially fire an alarm, and therefore could inadvertently send an unwanted email.
== Keyboard / Mouse Shortcuts ==


<hr>
<hr>

Revision as of 03:22, 9 February 2023

Back to Documentation Main


The underlying principle of SQL Agent Insight is the ability to set thresholds for metrics and be notified when these boundaries are breached, via email and/or desktop notifications. This is why it is of utmost importance to set these limits upon the first monitoring of a SQL Server instance.

A typical Insight showing expanded MS DB and Jobs categories along with their polled values and configured thresholds.

To modify thresholds for individual metrics, it is important to note that the Insight must be in one of two polling states, either Manual or Paused. This will be indicated in the status bar at the bottom right.

It is important to have the Insight in either a manual or paused state to prevent a poll midway through an editing cycle which could potentially fire an alarm, and therefore could inadvertently send an unwanted email.

Keyboard / Mouse Shortcuts


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