Revision as of 02:50, 9 February 2023

Polling Frequency

To receive updates to the polled values in a timely manner, each SQL instance monitored by an Insight has it’s own polling frequency accessible from within the Insight’s options dialog.

The dropdown for Polling interval will have the following frequencies defined:

Every 15 Seconds,
Every 30 Seconds,
Every 60 Seconds,
Every 5 Minutes,
Every 10 Minutes,
Every 15 Minutes,
Every 30 Minutes,
Every 1 Hour, and,
Manual.

The polling interval that is selected is conveniently shown in the status bar of the Insight. When a new interval is selected, the status bar will also show a progress bar in the bottom right indicating the amount of time before the next update.

Furthermore, any polling interval (other than manual) will set the Insight as active, meaning, that it’s status will be updated in the Connected SQL Servers pane within the main UI window. The status of an Insight with an active polling interval will either be in a healthy state, critical state or warning state, further indicated by it’s respective color.

Manual Polling

By selecting the manual polling option, metric gathering is effectively paused, and will be indicated in the status bar as Polling Interval: Manual. In addition, the Insight in the Connected SQL Servers pane will indicate manual polling by showing a grey colored bar in it’s margin.

Default Polling

By default, polling happens every 15 seconds unless changed after the start of monitoring for the SQL instance. Be sure to click on OK within the Insight Configuration; doing so will also save all options for the Insight.

Pausing Metric Data Collection

To stop the updating of metrics on a regular frequency, select the Play/Pause button in the Insight toolbar without changing the polling interval.

Resuming the collection of metrics (by pressing the same button again) will automatically restart the progress bar using the last known polling interval.

The Play/Pause button icon along with it’s tooltip will indicate the mode that is active for the Insight along with the polling interval indication in the status bar.

Error creating thumbnail: Unable to save thumbnail to destination Tip

When the Insight is in manual polling mode or metric collection has been paused, the metrics can be updated by simply pressing the Refresh Metrics button in the Insight toolbar for a one-time manual collection.

Recent Timeframe

Default Timeframe

Affected Metrics

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

@@ Line 26: / Line 26: @@
 == Default Polling ==
-By default, polling happens every 15 seconds unless changed after the start of monitoring for the SQL instance. Be sure to click on OK within the Insight Configuration; doing so will also save all options for the Insight.
+By default, polling happens every 15 seconds unless changed after the start of monitoring for the SQL instance. Be sure to click on <span style="color: dodgerblue;">'''OK'''</span> within the [[SQL Agent Insight:Documentation:Insight Configuration|Insight Configuration]]; doing so will also save all options for the Insight.
 == Pausing Metric Data Collection ==