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
Monitor multiple SQL Server Agents concurrently.
Monitored Servers Dashboard gives an overview of all monitored instances.
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.
Quickly and easily see the status of all jobs including start time and the predicted finish time based on average run time.
Visually see an individual job’s success rate, schedule(s), running time, number of historical executions, average and maximum duration.
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.
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.
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.
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.