Features of SQL Agent Insight

download SQL Agent Insight

SQL Agent Insight is a monitoring tool for Microsoft’s SQL Server Agent. It operates in the background allowing your DBA to focus on other critical day-to-day operations.

SQL Agent Insight is not a replacement for the native SQL Server Agent scheduler; it is distinguished from the native activity monitor and other products by providing an intuitive interface for determining problem areas across many monitored server instances without the requirement of installing an agent. Have a look at some of the key features below.

See how SQL Agent Insight compares to the native Job Activity Monitor in Management Studio and other products and why SQL Agent Insight is worth the free download. SQL Agent Insight is under continual development, adding features and improvements with each new release.


Monitor Multiple Instances Across Different Versions
Compatible with SQL Server Agent version 2005 through to version 2016.
Monitor multiple SQL Server Agents concurrently.
Monitored Servers Dashboard gives an overview of all monitored instances.

50+ Monitored Metrics
All metrics have their own configurable critical and warning thresholds for alerting and notification purposes.
Quickly determine key areas that have changed from configured thresholds with vibrant visual colors.
On-screen and e-mail alerting when thresholds have been breached.
Log long running jobs; determine what was running when and for how long.
Disable groups of metrics that do not require monitoring that may not be important for your organization.
Identify Future Job Contention
Gantt chart showing scheduled conflicting jobs, 3, 5 and 7 days in the future.
Quickly and easily see the status of all jobs including start time and the predicted finish time based on average run time.
Helps assist your DBA in pinpointing problem areas such as long running jobs.
Determine schedule conflicts before they become a problem.

Agent Job Monitor
Quickly identify jobs and their current execution status with easily identifiable status colors.
Visually see an individual job’s success rate, schedule(s), running time, number of historical executions, average and maximum duration.
Script any and all jobs.
Filter to show jobs of interest.

Job History
See much more than the native job history in SSMS, including total executions by status, job success rate, a visual timeline of job run times, and average run time.

Scripting Made Easy
Script all jobs for a monitored instance at once, making for easier backups and replication to other servers.
Script all database mail configuration settings, profiles and accounts with a single click of a button.
Script any job based on criteria such as category and schedule.

The Dashboard
A consolidated and concise view of all monitored instances.
Quickly see the most important metrics at a glance:
Total Monitored Systems, Active SQL Agent Services and DB Mail Sessions
Total Jobs, total running jobs and their overall success rate
Visually identify which systems are having issues and by clicking on its name, brings you direct to that Insight.

Schedule Summary
See all server schedules, which are enabled, friendly descriptions and all jobs associated with them.
Filters allow a DBA to show which schedules are not being used, or have been recently modified.

Database Mail
DB mail profiles and accounts easily accessible in one view; easier to use than going through a wizard.
Access to the database mail log and its summary without the need to write cumbersome T-SQL scripts.
Gain access to database mail items; quickly see which mail has been sent, not sent, retrying or has failed.

Other Notable Features
Visual taskbar notifications matching threshold severity along with e-mail alerting of trouble areas.
View all SQL agent registry values with the click of a mouse.
Visibility into all SQL agent log files consolidated into a single view.
SQL agent session history with current uptime reported.
MSDB database size and when it was last backed up.
Consolidated agent operators and job categories views.

No Installation Required
Clean, agent-less operation means nothing is installed on your SQL Servers, ever.
Nor is there any client-side installation required either.
T-SQL and SMO are the only methods of gathering the data that you require.
SQL Agent Insight runs directly from any folder or from a portable USB thumb drive. Requirements can be found here.