SQL Agent Insights:Documentation:Insight Overview

From SQL Agent Insights Wiki

Back to Documentation Main

The Insight is the key focal point for each monitored SQL Server instance within SQL Agent Insight. It is from here that one will spawn other actions that drive the monitoring experience.

Let’s break down a typical Insight into its major components. Knowing these locations and terminology will assist in the quick navigation of an Insight and monitoring session.

thumbnail
thumbnail

Main Toolbar

[[File:]]

Across the top of each Insight is presented:

  • The edition of SQL Server being monitored, the product level, along with it’s build number,
  • The most recent polled status of the SQL Server Agent service, and,
  • The toolbar containing shortcuts to all of the accessible features of a monitored instance. More on that below.

Metric Summary

Action Bar

Metric Details

Status Bar

Insight Log

Toolbar Options

An Insight toolbar has all of the options when working with the monitored instance of SQL Server. From left to right, they are:

Error creating thumbnail: Unable to save thumbnail to destination - Error creating thumbnail: Unable to save thumbnail to destination Pause/Resume Polling

At any time, active polling of your SQL Server instance can be started and stopped with this option and indicated within the Insight status bar.

Error creating thumbnail: Unable to save thumbnail to destination Refresh Metrics via a Manual Poll

No matter what option is selected for the polling interval, the refresh button will instantiate a connection to your monitored SQL Server instance and update the metrics at any time refreshing all values to the most recent.

Error creating thumbnail: Unable to save thumbnail to destination Job Monitor

Aside from the Insight, the Job Monitor will be the most used functionality for a monitored instance. The Job Monitor is a detailed window into the most useful data for each of your scheduled jobs. With more features than the default Job Activity Monitor in SQL Management Studio, monitoring your job infrastructure is intuitive and easy.

Error creating thumbnail: Unable to save thumbnail to destination Job Conflict Outlook

Another unique feature to SQL Agent Insight, the Job Conflict Outlook (“JCO”), allows the ability to peer into the future to see potential job run conflicts over the next 24 hours. The JCO does this by calculating all possible job runs and then determines if these conflict with any other scheduled jobs. These job run schedules are then represented in a Gantt style chart to easily see which jobs overlap. This helps in determining the optimal time to run those critical jobs without conflicts. For jobs to appear on the chart, they must:

  • have a schedule,
  • be enabled,
  • have a frequency greater than zero (i.e. run at least once in a 24 hour period),
  • be a local job (TSX type), and,
  • run at a minimum every 5 minutes. (Jobs that run more frequently, typically, are quick to run, and will likely conflict with a lot of other jobs).

Error creating thumbnail: Unable to save thumbnail to destination Log Viewer

Another one-up compared to the log viewer provided with SQL Management Studio, SQL Agent Insight’s Log Viewer shows just how large those SQL agent logs are, along with the ability to easily filter by severity or by message text to get to the root of a problem quickly.

Error creating thumbnail: Unable to save thumbnail to destination More Options

(which expands to the following)

Error creating thumbnail: Unable to save thumbnail to destination - Error creating thumbnail: Unable to save thumbnail to destination List Running Jobs (indicator)

This icon is represented as a “running person” image. By default, this icon is blue in color when running jobs are not being logged into the Insight log. When enabled, this icon will be green in color.

Error creating thumbnail: Unable to save thumbnail to destination - Error creating thumbnail: Unable to save thumbnail to destination Email Notifications (indicator)

This icon is represented as a “megaphone” image. By default, this icon is blue in color when email notifications are disabled / not configured. When enabled, this icon will be green in color.

Error creating thumbnail: Unable to save thumbnail to destination Insight Configuration

Everything that can be set with a monitored Insight is done via the Insight Configuration dialog.

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_Overview&oldid=1132"