Applies to: SQL Agent Insight version 0.23

Configuration of an Insight

In version 0.23 onwards, the Insight configuration dialog has been simplified to the following options:

POLLING INTERVAL

Set the polling interval to a value indicating the frequency in which the metrics should be updated. The dropdown has the following options:

  • Every 15 seconds
  • Every 30 seconds
  • Every 60 seconds
  • Every 5 minutes
  • Every 10 minutes
  • Every 15 minutes
  • Every 30 minutes
  • Every 1 hour
  • Manual

For a more in-depth understanding of how this option functions, please visit the Polling Frequency and Recent Timeframe page.

RECENT TIMEFRAME

The purpose of the recent timeframe selection allows the manipulation of some metrics that are best measured over a time period. This dropdown has the following options:

  • Every 3 days
  • Every 5 days
  • Every 7 days
  • Every 14 days
  • Every 30 days

For a more in-depth understanding of how this option functions, please visit the Polling Frequency and Recent Timeframe page.

LOG RUNNING JOBS

List running jobs to the Insight log once every polling interval. When enabled, the logging of running jobs indicator in the Insight toolbar will appear green in color.

■ NOTE
The LOG RUNNING JOBS option must be enabled to receive the long running job email notification.

ENABLE EMAIL NOTIFICATIONS

Toggle email notifications for this Insight only. When enabled, the email notifications indicator in the Insight toolbar will appear green in color.

■ NOTE
This option trumps that of the Global Email Notifications. If this option is disabled, notifications for this Insight will not be sent. Conversely, if this option is enabled and Global Email Notifications are disabled in the Preferences, notifications for this Insight will also not be sent.

Furthermore, this option must be enabled to received long running job emails.

VERIFY SQL INSTANCE CONNECTIVITY

SQL Agent Insight will check in with the monitored instance, a heartbeat, to ensure connectivity with the instance is still valid. The heartbeat can be configured every 10, 30, or 60 seconds.

LOG HEARTBEAT MESSAGES

Enabling this option will log the heartbeat connectivity message to the Insight log every 10, 30, or 60 seconds, depending on what is chosen for the verify option above.

ENABLE LONG RUNNING JOB EMAIL

To receive an email notification for jobs that run longer than a set time (in seconds), enable this option. A distinct email (outside of the normal threshold breach emails) will be sent each polling period for jobs exceeding the set time.

■ NOTE
The option ENABLE EMAIL NOTIFICATIONS must be enabled to receive this notification.
Additionally, Global email notifications must be enabled and configured correctly in SQL Agent Insight’ Preferences.
■ PRO TIP
It is recommended to have an overall Insight polling interval less than the number of seconds that need to elapse for a job to be considered ‘long running’. In doing so, SQL Agent Insight will capture all running jobs during that polling interval to the Insight Log tab of the Insight for later review.
The Insight configuration dialog.
Click to enlarge.