SQL Agent Insight version 0.22
From the example at the right, we can see that the SQL Agent Service is running (as indicated by the green checkmark at the left in the toolbar). Should the SQL Agent Service be stopped, this checkmark will be replaced by a red X.
Additionally, beside the status of the SQL Agent Service, in square brackets, is an indication of it’s multi-server status (if applicable).
A value of [MSX] indicates the SQL Agent is the Master server in the Multi Server Administration, whereas a value of [TSX: <master server instance>] will indicate that the SQL Agent is a Target server in the Multi Server Administration, with the name of it’s master indicated. A SQL Agent Service not participating in Multi Server Administration with neither show MSX or TSX.
An Insight toolbar has all of the options when working with the monitored instance of SQL Server.
From left to right, they are:
TOGGLE MINIMAL VIEW
PAUSE / RESUME POLLING
REFRESH METRICS VIA A MANUAL POLL
JOB CONFLICT OUTLOOK
MORE OPTIONS (which expands to the following)
- Database Mail Profiles & Accounts
- Database Mail Items
- Database Mail Event Log
- Registry Values
- Recent Timeframe
- Copy filtered Insight log to clipboard
- Clear entire Insight log
LIST RUNNING JOBS (Indicator)
E-MAIL NOTIFICATIONS (Indicator)
Primary Working Area
Directly below the toolbar and under the SQL Agent Service status, there are two (2) tabs. The default, which is the Detailed Metrics Scorecard, and the second, the Insight Log.
The primary focus of any Insight are the metrics, of which there are 63 values that determine the overall state of the Insight.
|■ PRO TIP|
Double-clicking on any metric group name will automatically put all of the metrics in that group into maintenance mode. This is a quicker way of achieving that goal without going into the Insight Configuration.
Directly below the primary working area, which showcases all of the metrics and their current state, is a typical status bar displaying important information on the state of the current Insight along with some settings values. Possible status bar entries from left to right include:
- The state of the connection to the SQL Server instance with an indication of the authentication method, either Windows or SQL,
- The Polling interval (in seconds),
- The last update date and time with the refresh time in square brackets,
- The current recent timeframe selection (in days, indicated by a small graphical icon),
- And, when the next automatic update / poll will happen to refresh the metrics, indicated by a progress bar.