Applies to:

SQL Agent Insight version 0.22

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 the “More options…” button in the Insight toolbar.

From the More Options button, select Polling and a submenu will appear with the following interval selections:

  • 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 to the left. The status of an Insight with an active polling interval will either be in a healthy state, critical state or warning state, with an icon indicative of the state.

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 icon for the Insight in the Connected SQL Servers pane will indicate manual polling by showing a raised hand indicating “stop”.

Default Polling

By default, polling happens every 15 seconds unless changed after the start of monitoring for the SQL instance. To save the updated polling interval, open the Insight Configuration and be sure to save the thresholds to file. 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.

■ PRO 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.
The polling frequency options within an Insight.
Click to enlarge.

Recent Timeframe

The purpose of the recent timeframe selection allows the manipulation of some metrics that are best measured over a time period.

For all “recent / recently” metrics, the value represented for the metric is within the recent time frame selected, by default, this is a period of 3 days. Therefore, the metric represents a value from the time of the most recent poll minus 3 days. The recent time frame can be changed in the dropdown menu, More Options, in the toolbar of the Insight.

  • For example: Total sessions could indicate a value of 312, meaning that the SQL Agent has been started and has a record of 312 sessions.
    However, the metric for Recent sessions should indicate a value less than or equal to that of the total, meaning it has been started recently (and by default in the past 3 days), this number of times.

The recent timeframe option is available from the “More options…” button in the Insight toolbar, select Recent Timeframe and a submenu will appear with the following interval selections:

  • 3 days,
  • 5 days,
  • 7 days,
  • 14 days, and,
  • 30 days.

The recent timeframe that is selected is conveniently shown in the status bar of the Insight, indicated by an icon indicative of the value selected in the menu.

Default Timeframe

By default, the recent timeframe is set to 3 days. To save the updated recent timeframe, open the Insight Configuration and be sure to save the thresholds to file. Doing so will also save all options for the Insight.

Affected Metrics

The following metrics are directly affected by the value selected for the recent timeframe and after a new poll has collected the data, either automatically or manually.

  • Sessions
    • Recent
  • Schedules
    • Recently Created
    • Recently Modified
  • Jobs
    • Recently Created
    • Recently Modified
    • Recently Failed
    • Recently Cancelled
  • Database Mail
    • Recently Sent
    • Recently Failed
    • Recent Errors
    • Recent Events
  • Multi Server
    • Recently Added Targets

The recent timeframe options within an Insight.
Click to enlarge.