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

From SQL Agent Insights Wiki
Line 70: Line 70:
=== Enable Extended Pause Notifications Email ===
=== Enable Extended Pause Notifications Email ===


* A distinct email will be sent every set interval notifying that the monitored instance has been paused.
* A distinct email will be sent every ''Extended Pause Notification Interval'' notifying that the monitored instance has been paused. This interval is configured on the ''General'' tab.
* This can be useful in situations whereby a loss of communication with the instance occurs.
* This can be useful in situations whereby a loss of communication with the instance occurs.


Revision as of 04:10, 8 February 2023

Back to Documentation Main

Configuration of an Insight

General

The Insight configuration window showing the options on the General tab.

Polling Interval

  • The frequency at which data will be refreshed from the SQL instance.

Recent Timeframe

  • The number of days prior to today when gathering recent metrics.

Log Running Jobs

  • List running jobs to the Insight log once every polling interval. This must be enabled for long running job notifications.

Verify SQL Instance Connectivity

  • Each Insight does a background check to see if the monitored instance is still available. This setting allows the Insight to check every 10, 30, or 60 seconds. Optionally toggling this off does not check for connectivity.
  • It is suggested to leave this on if you are actively doing actions with your SQL agent which can alert you ahead of time of any errors.

Log Heartbeat Messages

  • Toggles the ability to log heartbeat messages to the Insight log. Disabling this option can reduce the amount written to the Insight log.

Long Running Job Interval

  • The number of seconds that need to elapse before a job is classified as long running for notification purposes.
  • It is recommended to have an overall Insight polling interval less than this value so that long running jobs will be captured appropriately to the Insight log.

Extended Pause Notification Interval

The frequency at which paused notifications are logged and or emailed.

Notifications

The Insight configuration window showing the options on the Notifications tab.

Enable Email Notifications

  • Toggle this on to receive notifications for this Insight. The megaphone icon on the Insight toolbar will appear green when this in on.
  • This must be toggled on for long running job notifications.


Error creating thumbnail: Unable to save thumbnail to destination Attention

Global email notifications must be enabled in Preferences for individual Insight notifications to work correctly.

Enable Long Running Job Email

  • A distinct email will be sent indicating jobs that run longer than the configured long running job interval on the General tab.


Error creating thumbnail: Unable to save thumbnail to destination Attention

The option Enable email notifications must be toggled on.
Log running jobs on the General tab must be enabled.

Enable Extended Pause Notifications Email

  • A distinct email will be sent every Extended Pause Notification Interval notifying that the monitored instance has been paused. This interval is configured on the General tab.
  • This can be useful in situations whereby a loss of communication with the instance occurs.


Error creating thumbnail: Unable to save thumbnail to destination Attention

The option Enable email notifications must be toggled on.

Category Polling

The Insight configuration window showing the options on the Category Polling tab.

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

Retrieved from "https://brentec.ca/wiki/index.php?title=SQL_Agent_Insights:Documentation:Insight_Configuration&oldid=1283"