Home Blog Contact Us
Brentec I.T. Solutions
SQL Server and SharePoint Consulting and the home of SQL Agent Insight

SQL Agent Insight
Version 0.10.5395.0


Version 0.10.5395.0 (released: October 10, 2014)

New Features

  • Schedule Summary - shows all agent schedules and their associated jobs; helps determine which schedules are not being used.

Improvements

  • The SQL Agent log now has its own window making it easier to view larger agent logs and prevents the Insight from slowing down when larger logs are being reviewed.
  • Chart tooltips in Job Conflict Summary now show and estimated completion time for jobs based on the average running time of the job's history.
  • Chart axis markings in Job Conflict Summary are more distinct making them easier to distinguish from plotted data.
  • On the main form, the option to show/hide all panels at once instead of individually, cleaning up the interface.
  • Threshold configuration dialog tabs now multi-line so scrolling is prevented to get to other tabs.
  • Recent server list now stores the FQDN (fully qualified domain name) of a server along with the specific port if not the default of 1433. Especially helpful when connecting to a remote server, e.g. Windows Azure.
  • Taskbar notification icon now has option to bring up Monitored Server Summary window directly.
  • Due to the size of some charts in Job Conflict Summary, the window has been given the option to be fully maximized within the parent window.
  • Within the insight log tab of each Insight, options to clear and copy the log have been moved here instead of in the Insight toolbar.
  • Agent Job Monitor allowed the highlighting of job row. This has been removed since this didn't have any purpose/functionality.

Bug Fixes

  • Job Conflict Summary
    • Tooltip flickering on mouse-hover over bar graph along with increased CPU usage has been resolved.
    • Jobs which ran longer than 24 hours would throw an error when trying to be converted to hh:mm:ss format in the Average and Maximum run time columns.
    • Jobs that started in the AM and had an end time in the AM (e.g. start at 7AM and end at 1AM) were not being accounted for correctly therefore showing an incorrect number of executions and potential conflicts and resulting in less data plotted on chart.
    • If selecting all jobs by a certain schedule name, all schedules with that name were being selected. This was resolved by selecting the data by schedule ID instead.
  • Insight
    • Incorrect status shown for SQL Agent during a failed communication with the server; wasn't being updated.
    • When a communication error with the server would occur, some form items were not being disabled.
    • Metric tooltips were not showing the correct threshold values for the Insight being monitored. When monitoring more than one SQL Agent, the values in the tooltips were of the latest monitored server.
  • Taskbar Notification Icon
    • Was not accurately showing the correct state of all monitored Insights when at least one monitored Insight was in a warning (yellow) state.

Version 0.9.5326.0 (released: August 2, 2014) [Click here to expand details on this version]
Version 0.8.5044.5142 (released: February 1, 2014) [Click here to expand details on this version]
Version 0.8.5044.0 (released: November 24, 2013) [Click here to expand details on this version]
Version 0.7.4993.38253 (released: September 3, 2013) [Click here to expand details on this version]
Version 0.7.4940.40409 (released: July 12, 2013) [Click here to expand details on this version]
Version 0.7.4937.29832 (released: July 10, 2013) [Click here to expand details on this version]
Version 0.6.4690.19204 (released: November 3, 2012) [Click here to expand details on this version]
Version 0.6.4642.35879 (released: September 24, 2012) [Click here to expand details on this version]
Version 0.5.4436.41566 (released: February 24, 2012) [Click here to expand details on this version]
Version 0.4.4376.42122 (released: December 26, 2011) [Click here to expand details on this version]
Version 0.3.4203.40911 (released: July 24, 2011) [Click here to expand details on this version]
Version 0.2.3992.37600 (released: December 10, 2010) [Click here to expand details on this version]
Version 0.1.3768.38938 (released: April 20, 2010) [Click here to expand details on this version]