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 with an intuitive interface for determining problem areas.

Contact   |   Link To Product   |   More Products By This Company

Specifications

Details

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 additional features below.

It Just Works!

Compatible with SQL Server Agent 2005, 2008, 2008 R2, 2012 and with the latest version, 2014!!
Monitor multiple SQL Server Agents concurrently and use the Monitored Servers Dashboard to get a overview of all monitored instances of SQL.

Metric Monitoring

50 monitored SQL Server Agent metrics including Jobs, Schedules, Alerts, Operators, Categories along with Database Mail.

Quickly determine key areas within SQL Server Agent that have changed from configured thresholds with vibrant visual threshold colors along with e-mail and on-screen notifications.
Threshold configuration with options to reuse for future monitoring sessions.
Critical threshold logging for later review, including the ability to log job names at the time of polling. Very handy when a DBA is not in front of their monitor and they need to know which jobs were running at a given time in the past.

Identify Job Contention

Visually see which jobs are conflicting with other scheduled jobs, 3, 5 and 7 days in the future, right down to the second. No other product allows the DBA to see when a job will run in the future and what other potential jobs it will conflict with. All other products show the past, SQL Agent Insight shows the future!
Quickly and easily see the status of all jobs including start time and the predicted finish time based on average run time. This can assist the DBA in pinpointing problem areas such as long running jobs BEFORE they become a problem.

Scripting Made Easy

SQL Agent Insight allows a DBA to 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 the single click of button.

Agent Job Monitor

Quickly identify jobs and their current execution status using the intuitive Agent Job Monitor. Now you can easily see which jobs are currently executing, which ones have been canceled or have errors, with easily identifiable status colors.

Schedule Summary

SQL Agent Insight can assist by showing jobs that do not have schedules along with schedules that do not have any jobs associated with them; great for cleaning up instances that may have been managed by another DBA previously.
Database Mail

DB mail profiles and accounts easily accessible in one view, easier to use than the cumbersome wizard in SSMS.
Access to the database mail log and its summary without the need to write cumbersome t-sql scripts.
No Installation Required!

Agentless operation means nothing is installed on your SQL Servers, ever. Furthermore, tracing is not done either to reduce load on your servers. T-SQL and SMO are the only methods of gathering the data that you require.
No installation on the client either. SQL Agent Insight runs directly from any folder or from a portable USB thumbdrive. The only requirements are a .NET 2.0 compatible operating system.

Tags

monitor, sql agent, portable, free, sql server, Database, agentless