SQL Agent Insight Change Log

download SQL Agent Insight

Version 0.17.040417.0 (released: April 10, 2017)

Known Issues:

  • An issue specifically with the Insight Log tab. In testing, a log growing to a significant number of rows ( >10000) suffers from a screen painting issue making SQL Agent Insight behave slowly when the Insight form is resized, specifically when toggling minimal view. This behavior originated in release 0.16.082216.0 when the logging was switched from plain text to a datagrid to better facilitate searching of the log, and only recently discovered through prolonged testing. This bug fix will be a primary concern for the next release.

New Features

  • SQL Agent Job History!
    • In Agent Job Monitor, right-click a job and check out its history. So much more included than the native SSMS view including a job success rate and total executions by status chart as well as a bar chart showing all previous job run times, along with the average run time. Mouse hovering over these charts gives further details.
  • Agent Job Monitor
    • An additional horizontal bar chart column showing the individual job success rate.
    • The ability to script jobs belonging to certain schedules.
  • Main
    • Quick Access Pane! Instead of using and scrolling through the built-in “Window >> More Windows” option, a quick access panel to the right of the main form now lists all open dialogs grouped by monitored server, giving a one-click option to bring that dialog to the forefront when needed. This pane is also collapsible, freeing up more screen real estate.
  • Agent Sessions
    • New Insight option to show all agent sessions, their start time and the option to view its log file if applicable. This window can also be invoked by clicking on the appropriate agent sessions metric within each Insight.
  • Agent Operators
    • New Insight option to show all agent operator information. This window can also be invoked by clicking on the appropriate operator metrics from within each Insight.
  • End-User License Agreement (EULA)
    • Specifically section 1a and spelling throughout.

Improvements

  • Overall
    • Many UI changes, including flat buttons, tool-strips, and consistent icon padding.
    • All windows (with the exception of an Insight and the Dashboard) can now be maximized.
    • Toggle switch icons instead of check-boxes.
    • Filter panels (where applicable) revamped and are now collapsible, allowing for more screen real estate.
    • All windows that have filter panels, the verbiage ‘showing x of y items’ is now on all and is colored red for anything less than a full view of items.
  •  About
    • Removed references to libraries no longer being used.
  • Target Servers Status
    • Tool-tip text on the reset button changed to be more appropriate.
  • Agent Job Monitor
    • Context menu organized better based on function.
    • Number of targets column now only shows a value if one is appropriate, reducing UI clutter allowing for easier readability.
    • Number of schedules column now only shows a value if one is appropriate, reducing UI clutter allowing for easier readability.
    • Help icon changed to be consistent with remainder of the application.
    • Only one script window will open based on the scripting option selected, reducing UI clutter.
    • Clicking on the number of targets value will bring up the Targets Server Status window.
    • Italic fonts have been removed for easier readability.
  • Schedule Summary
    • Number of schedules column now only shows a value if one is appropriate, reducing UI clutter allowing for easier readability.
  • Database Mail Forms
    • Icon changes to make them less ambiguous with each other and more identifiable/unique.
  • Monitored Servers Dashboard
    • Removed the tool-tip when hovering on the healthy metrics, reducing UI clutter.
    • Combined like cards. That is, like metrics are combined into one.
  • Insight
    • Changed the text for the recent time-frame to an icon which represents that time-frame instead.
  • Main
    • Collapsible server pane, freeing up more screen real estate.
  • Database Mail Config
    • Removed status bar verbiage ‘Total Log Entries’. Was not needed.
  • Configuration
    • Verbiage notifying user that changes have been detected has been moved to the status bar.
  • Thresholds Configuration
    • When any thresholds have been modified, verbiage now displayed in status bar along with a confirmation dialog displayed to save/apply.
    • Not all button that would ‘zero’ thresholds had a tool-tip. Since version 0.16.082216.0.

Bug Fixes

  • Main
    • Unhandled exceptions if eula.txt and sqlai.ini files missing, renamed or corrupt.
  • Insight
    • An index out-of-range exception would occur if the tool-tip for the SQL Agent status was displayed at the exact same time as a server polling request.
  • Agent Job Monitor
    • Average run time no longer showing asterisks (*). Was a result of SQL storing negative run times in its system tables as a result of a job being run at the exact time of a system time change, for example, during daylight savings changes.
  • Job Conflict Outlook
    • Average run time no longer showing asterisks (*). Was a result of SQL storing negative run times in its system tables as a result of a job being run at the exact time of a system time change, for example, during daylight savings changes.
    • Resolved context menu unhandled exceptions which appeared in some cases when selecting an option where the job name was ‘…’. Since version 0.13.5617.0.
  • Configuration
    • The ‘show monitored servers dashboard on startup’ toggle now represents the saved value. Was not being saved to the .ini file properly since version 0.9.5326.0.
  • Database Mail Event Log
    • Clicking on the refresh button repeatedly caused an exception. Since version 0.15.5857.0
  • Database Mail Items
    • Clicking on the refresh button repeatedly caused an exception. Since version 0.15.5857.0
  • About
    • User was able to close the window without accepting the EULA.

Version 0.16.082216.0 (released: September 1, 2016) - Click to Expand

November 18, 2016 Attention

  • It has been noted that during a time change scenario, as was recently experienced in the Eastern Time zone on November 6, if jobs were scheduled at 2:00am (such as syspolicy_purge_history), i.e. the time at which systems automatically set the clock back 1 hour, the entries within the msdb.dbo.sysjobhistory table under the run_duration column *may* have a large negative value, which skews the results in SQL Agent Insight within the Agent Job Monitor, specifically the “Average Run Time” column appearing malformed. This will be resolved in the next build.

New Features

  • Enumeration and monitoring of SQL Server 2016 instances is available!
  • SQL Agent registry values now accessible.
  • Category Summary showing the name, type and the number of jobs in that category.
  • Category information now available per job in Agent Job Monitor.
  • The ability to script all jobs belonging to a particular category in Agent Job Monitor.
  • Shortcut to category information by clicking on the category metrics within an Insight.
  • Agent Job Monitor now shows the number of schedules and their names with a mouse-over, and with a click opens the schedule summary dialog.
  • For each Insight, putting your mouse cursor over the status of the SQL Agent reveals a number of additional gathered information.
  • Double-clicking on a group of metrics within an Insight renders those metrics in maintenance mode without the need to open the Threshold configuration.
  • New metrics for each Insight:
    • Multi-Server; # of Jobs
    • Agent Sessions; Current up-time, Total Sessions and Recent Sessions
  • Threshold Configuration now has the optiosn to reset all critical and warning thresholds to the current polled values or to zero.

Improvements

  • Many UI visual enhancements to maintain consistency including flat buttons without focus cues.
  • User must accept the EULA before running SQL Agent Insight.
  • Filter text can now be clicked to select in addition the to the traditional checkbox.
  • Main form toolbar icons are larger with descriptive text for ease-of-use.
  • Most forms can now be maximized for better reading and scrolling capabilities.
  • Can now double-click on an enumerated server name to open a connection.
  • Instance version no longer shown beside enumerated server name; although it is visible with a mouse-over.
  • Upon establishing a connection, user will know if the SQL agent is running.
  • Job Conflict Outlook data gathering is now a background process indicated with text in the status bar. Previously this would cause the user to wait until finished.
  • Job Conflict Outlook now has a “Refresh Table” button to prevent the user from closing and reopening to refresh the data.
  • Insight log text column no longer truncating text.
  • Threshold Configuration is now modal to prevent numerous threshold configuration dialogs on the screen at any given time.
  • When dealing with thresholds with values over 1000, removed the thousands separator to be consistent with polled values within the Insight.
  • Long running job pre-requisites are now visually identifiable as red/green depending on their status, instead of grey.

Bug Fixes

  • The polling value of an individual Insight was not being reflected properly on the dashboard.
  • When child forms were maximized and a form was opened (e.g. Connection) that wasn’t intended to be maximized had drawing issues.
  • No more duplicate instances within the connection dialog server drop down.
  • Agent XPs advanced option is tested prior to connection to prevent an error on Insight load if the SQL Agent service was not running.
  • Job Conflict Outlook – “System.ArgumentOutOfRangeException: Index was out of range.” error resolved. Root cause was a job with more than one schedule when charted.
  • Insight data collection exception error now does not take up entire screen with a message box.
  • Not all threshold configurations were being loaded from a saved file for multi-server metrics.
  • Legacy context menu for the Threshold configuration has been removed in favor of items in the toolbar.
  • Decimal precision for MSDB size and number of attachments metrics.
  • Job Conflict Outlook form will only close when the background data gathering has finished to prevent errors on close.


Version 0.15.5857.0 (released: January 23, 2016) - Click to Expand

New Features

  • The SQL Agent type, i.e. Standalone, MSX (master) or TSX (target) is now being shown alongside the agent status.
  • Users can now view any one of the total SQL Agent logs for the instance. Previously only the most recent log could be viewed.
  • New MSX/TSX (master/target) server metrics, including:
    • Number of target servers referenced by a master.
    • Recently added target servers.
    • Number of unread instructions waiting in the queue at the master to be downloaded by a target server.
  • Clicking on any of the new master/target server metrics while monitoring a MSX server, will show a new dialog indicating all target servers along with the status of any instructions with the ability to filter by target server.
  • New metric for each Insight: Job Success Rate which shows the total number of job successes as a percentage of the total number of job executions.
  • Agent Job Monitor
    • Now shows the job type (i.e. local or multiserver) and the number of target servers. On mouse-over of the target servers, a tooltip will show the names of the targets IF the job type is multiserver.
    • Visually shows multiserver jobs as a different color.
    • Has new filters to accommodate the additional of the multiserver jobs.

Improvements

  • Monitored Servers Dashboard overhaul. Updated to include cards showing the following across ALL monitored instances:
    • Total Monitored Systems
    • Active SQL Agent Services
    • Active DB Mail Sessions
    • Total Jobs
    • Total Running Jobs
    • Job Success Rate
    • Totals for current healthy, critical, warning, and in-maintenance systems
    • Totals for current healthy, critical, warning, and in-maintenance metrics
  • Changed layout of metrics on the Insight form.
  • The Metrics Scorecard Summary within each Insight has been visually updated to match that of the Monitored Servers Dashboard.
  • The ability to change color schemes has been removed from this version.
  • Some context menu icons were missed during updating in the last version, updated in this version.
  • The Insight log control was changed to facilitate better and quicker logging along with quicker searching capabilities.
  • The Agent Job Monitor dialog can now be sized larger.
  • Search input fields across all forms modified to operate similar to that of Windows Explorer.
  • Clicking on any card  within the Metric Scorecard Summary (i.e. in minimal view) will now expand the Insight back to normal/full view.
  • Verbiage changed when a user attempts to script a job and the necessary SQL SMO and CLR types are not installed.
  • Job Conflict Outlook context menu changes for charting.
  • Visually improved the refresh of the Agent Job Monitor dialog.
  • Ordering of columns within the Monitored Servers Dashboard has been tweaked.

Bug Fixes

  • The unhandled exception thrown when a user opened the “Configure Thresholds” from an Insight while a new connection dialog was open has been resolved.
  • If Insight thresholds were applied while actively monitoring an instance, the next update progress bar would reset to the minimum and the next poll would happen when the progress bar was not full.
  • An Insight is now flagged as critical if an Insight were to lose connectivity to the server, previously the Insight would be marked as in maintenance.
  • Searching the Insight log is now much faster. Previous versions resulted in a UI slowdown as the log grew.
  • The status of the SQL Agent service is now being shown correctly in the Insight log.
  • The dashboard now comes to the foreground when the option from the taskbar icon is selected while the dashboard was minimized.
  • Monitored servers with a case-sensitive collation is now working correctly.
  • Job Conflict Outlook now uses the end-users regional (culture) settings to prevent incorrect date conversions within the form.
  • The exception “The expression contains an invalid string constant: ‘)” no longer appears within the Database Mail Items form.
  • Only one Database Mail Event Log form opens now after clicking on the mail item ID within the Database Mail Items form.
  • A bug introduced in version 0.14 whereby some controls within the Thresholds configuration would not get disabled after clicking on the bypass checkbox in each tab has been resolved.
  • Blank/Empty values for critical/warning thresholds are no longer allowed and were going unchecked allowing the user to save and use these values which would not validate correctly against polled metrics.
  • The thresholds for “Jobs: Recently Modified” are now being saved correctly to file for later use.

Version 0.14.5738.0 (released: September 18, 2015) - Click to Expand

Update September 21, 2015 – a bug has been introduced in this build that will return an unhandled exception error when a user attempts to open the “Configure Thresholds” dialog (gear icon) from an Insight. This happens when an existing Connection dialog is open and the user attempts to open the Configure Thresholds dialog. To workaround this issue, click “Continue” on the unhandled exception error, close ANY open connection dialogs that exist, and then open the Configure Thresholds dialog again.

Apologies for any inconvenience that this may cause and under normal working conditions this will not affect the operation of SQL Agent Insight using the workaround above. Rest assured, the bug has been fixed for the next build, version 0.15.

New Features

  • SQL Agent Insight now requires the .NET 4.5.1 framework. Previous versions only required .NET 2.0. Making this change allows Brentec to bring a better features and more improvements/efficiencies to the UI and the back-end coding. One such example is the integration of the Microsoft Chart Control in the Job Conflict Outlook. Please check our requirements page for further information with this new release.
  • An Insight (when configured through Thresholds dialog) will now send e-mail notifications (provided they are enabled and configured) when jobs run longer than desired. For example, if a job runs longer than 30 minutes, an e-mail notification will be sent out indicating as such.
  • The Agent Job Monitor now indicates how long a job has been running for (if not idle) and who (user or system) started the job.
  • The Monitored Servers Dashboard now has tooltips of each metric status indicating the underlying metrics that fall into that category for quick reference.
  • Insight log is now searchable, and each instance of the search is highlighted.

Improvements

  • Minimal view metrics now show tooltips containing the Insight metrics that have the status indicated (metric tooltips must be turned on in the main configuration).
  • When thresholds are changed per Insight, they are logged to the Insight Log tab along with the values changed.
  • Insight log now shows when thresholds have been loaded/saved.
  • Insight log now indicates how long a job has been running for if the option to show running jobs has been checked.
  • Connection dialog is now a background process so that a failed connection does not appear to pause the entire interface.
  • Job Conflict Summary is now Job Conflict Outlook, better indicating that this form shows future conflicts.
  • Many small UI tweaks to labels and status bars for product consistency reasons.
  • Connection dialog now has a tooltip on the server field indicating the proper syntax for referencing a SQL instance.
  • Monitored Servers Summary is now Monitored Servers Dashboard, better indicating the purpose of this form.
  • Overall graphical icon overhaul. Now using an icon set from icons8.com for UI consistency.
  • Job Conflict Outlook has had a complete overhaul in appearance and functionality.
    • Back-end algorithms for detecting job conflicts has been improved considerably.
    • Plotted jobs on the chart are now either red or green, meaning they conflict with another job or do not, respectively.
    • More of the context menu items are now in the toolbar for quicker access to important items.
  • The main configuration dialog keyboard shortcut was CTRL+C, which conflicts with the Windows copy command. This has been changed to CTRL+ALT+C.

Bug Fixes

  • In some instances clicking on the “number of executions” column in Agent Job Monitor to sort would generate an exception. This has been resolved.
  • When a user would click on the “Apply” button in the thresholds configuration dialog, the “list running jobs” and “e-mail notifications” buttons on the Insight would get turned off. This is no longer the behavior, unless these settings were loaded from a configuration and then applied.
  • In some cases, the background coloring indicating the status of the metrics were not being populated correctly on startup. Resolved.
  • The send test e-mail button is now being disabled if global e-mail notifications are disabled. Previously this button was still active.
  • The main configuration dialog no longer prompts the user twice asking if they are sure they want to exit without saving. This was happening when the escape key was pressed to close the form.
  • A bug introduced in v0.13 whereby a user would click on any schedule metric, the filter would not be applied on the resulting schedule summary dialog. This has been resolved in v0.14.
  • The load default threshold configuration button now loads the correct underlying DEFAULT thresholds file. This was loading one named after the server instead of the common default.
  • Attempting to save the recent server file list resulted in an exception if the file was in a read-only state. Checking is in place for this now.
  • Previously the connection dialog was restricting the valid character set for a server instance name based on the English language. However, if a non-English character set is being used, not all server instances could be connected to. This restriction has been lifted since server names can have unicode 2.0 characters within them as per Microsoft documentation.

Version 0.13.5617.0 (released: May 20, 2015) - Click to Expand

New Features

  • New window option to minimize all forms except Insights.

Improvements

  • Multiple aesthetic changes to various forms; updated tool-strip menu items, icon consistency across forms, date display consistency to ISO format YYYY-MM-DD.
  • Refresh buttons on SQL Agent Log, DB Mail Items, and DB Mail Event Log forms now reload data from server so user does not have to close form and re-open to get fresh data.
  • Shortcut key bindings have been updated to better reflect the underlying menu option.
  • Script output form can now be minimized if required.

Bug Fixes

  • Resolved a scenario when a child window to an Insight would become orphaned if the child form was busy because of a background worker thread that was not finished its work.
  • Resolved the situation whereby not all MDI forms would appear in the “Window” menu list.
  • Resolved the situation whereby scripting in the Agent Job Monitor would not work when connected to a SQL instance over a non-default port.
  • Resolved a scenario in the Agent Job Monitor when scripting a job with an apostrophe (‘) in the name would generate no output.
  • Resolved the situation in the Job Conflict Summary for a job with an apostrophe (‘) in the name would not show any job timing information.
  • Resolved a situation on the Schedule Summary form not showing the correct number of jobs using a particular schedule that had an apostrophe (‘) in the name.
  • Resolved all form searching errors that resulted from invalid characters being input. These characters are now being escaped properly. Characters included ‘ % * [ ]

Version 0.12.5597.0 (released: April 30, 2015) - Click to Expand

New Features

  • Agent Job Monitor now displays the average and maximum run times for each job. Useful statistics for quick review.

Improvements

  • Certain forms have been renamed to better indicate their functionality:
    • Database Mail Items was Database Mail Summary
    • Database Mail Event Log was Database Mail Log Summary
    • Monitored Servers Dashboard was Monitored Servers Summary
  • The following forms have had their search capability improved significantly in this build, allowing for a more dynamic (per character) search:
    • SQL Agent Log, Database Mail Items, Database Mail Event Log

Bug Fixes

  • The following forms with this build now use a fundamentally different method to fetch and show the data coming from the monitored server, therefore rendering large data sets much more quickly and in a background thread.
    • SQL Agent Log (tested successfully with a log containing 77,000+ items)
    • Database Mail Items (tested successfully with a history table of over 6,500 items)
    • Database Mail Event Log (tested successfully with an event history of 11,000+ items)

Version 0.11.5559.0 (released: March 24, 2015) - Click to Expand

Update April 29, 2015 – Version 0.12 will be released in the very near future and with it comes fixes when viewing and searching agent and database logs of significant size with CPU performance issues removed. Please return for future updates or follow Brentec on Twitter for immediate news of the release. Apologies for any inconvenience this may have caused.

Update April 14, 2015 – While this latest release introduces a significant number of changes that are exciting and useful, there have been some issues discovered that did not appear during initial testing; viewing and searching agent logs and database mail logs of significant size can cause CPU performance issues on the client machine running SQL Agent Insight, not the SQL Server being monitored. Brentec is aware of these issues and is actively working on them to be fixed in the next version. Thank you for your patience in this matter.

New Features

  • Tested in Windows 10 Technical Previews 9226 and 10041, no issues logged.
  • Different metric color schemes available in the main configuration dialog, 4 to choose from at this time.
  • Database Mail status is now being monitored.
    • New Database Mail Profiles and Accounts dialog showing all profiles and associated accounts in one dialog, without the cumbersome wizard prevalent in SSMS. Furthermore, inactive accounts are shown to easily detect which are not in use, and, the primary account for any profile is also shown.
    • Database Mail metrics are now clickable opening up further dialogs of insight.
    • New database mail metrics being monitored, e.g. most recently failed database mail items, recently sent, number of mail profiles, recent events, total, retrying, etc.
    • New Database Mail Summary dialog
    • New Database Mail Log Summary dialog
    • New Database Mail Configuration settings dialog.
    • The ability to script all database mail configuration settings, profiles and accounts with a click of a button, for easier backup purposes.
    • Database Mail profiles show their public/private status, along with their default setting, along with last modified date/time and by whom.
  • Searching features now implemented in the following dialogs:
    • SQL Agent Log
    • DB Mail Summary
    • DB Mail Log Summary
    • Schedule Summary
  • Connection dialog now shows what has been happening all along in the background, i.e. the requirements for each connection.
  • Threshold configuration dialog for each Insight now has a toggle button to disable/enable all metrics with the click of a button making this easier to put a monitored system in “maintenance” mode.

Improvements

  • Monitored Servers Summary – version and edition are now displayed alongside server name.
  • Can now right-click to enumerate servers in the ‘Available SQL Servers’ pane.
  • The status bar of each Insight now shows the recent timeframe for polling so that one doesn’t have to bring up the context menu to see this.
  • Metrics scorecard summary has a tweaked layout.
  • Monitored Servers Summary updates the status bar upon last server update.
  • When saving the Insight configuration thresholds, an invalid threshold value would trigger an error message in the status bar, but this went unnoticed. Changed the text to red (from black) to bring more attention to this.
  • Monitored Servers Summary – when clicking on a server, this would bring the Insight in question to the foreground, but on some systems, due to the aero/color theme, the active Insight was hard to notice. Therefore, the color of the toolbar of the active Insight is now distinct, making it noticeably visible.
  • Tooltip on notification icon in the system tray does not include the version number with this build.
  • About dialog has direct links to our Twitter and Donate pages.

Bug Fixes

  • When user clicks the close button on the main window, SQL Agent Insight now prompts to close, just in case active Insights were open.
  • The option to list running jobs when toggled was not being saved to the Insight’s configuration file. This has been resolved.
  • Although the state of the suppress e-mail button within an Insight was being saved and read from the configuration file correctly, the state of the toggle button wasn’t being updated properly. This has been resolved.

Version 0.10.5395.0 (released: October 10, 2014) - Click to Expand

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 to Expand

New Features

  • Successfully tested with SQL Server 2014 Agent!
  • 5 new monitored metrics!
    • MSDB size
    • Last full backup of MSDB
    • Recently failed jobs
    • Recently canceled jobs
    • Jobs that have never run
  • Monitored Servers Summary – a consolidated view showing all monitored servers, for a quick glance at all monitored systems, with a configuration option to show this form on application startup.
  • Option to prevent sleep mode and the screen saver from invoking. Beneficial when used in a NOC environment.

Improvements

  • The option to open a recently connected server by double-clicking its name.
  • Job Conflict Summary dialog can now be resized to show more information on the screen.
  • Restoration of SQL Agent Insight from minimized view now brings it to the foreground.
  • Progressbar on each Insight visually indicates when the next update for that Insight will occur.
  • Metric tooltips now show more detailed information, including a description of the metric and the thresholds associated with it.

Bug Fixes

  • On occasion the Job Conflict Summary would show “N/A” for times in the view. This has been resolved in this build.
  • In the Job Conflict Summary, the sizes of the column headers are now wider allowing for a better view of the data.
  • When an Insight was put into minimal view, the status of the server was always reported in good standing even if it wasn’t; this has been resolved in this build.
  • Closing an Insight now prompts the user to ensure the action is desired.
  • Double-clicking on the tray icon or a monitored system in the tray icon would not bring SQL Agent Insight to the foreground and the top most application; this has been resolved in this build.

Version 0.8.5044.5142 (released: February 1, 2014) - Click to Expand

New Features

  • None.

Improvements

  • None.

Bug Fixes

  • A discrepancy arose whereby users with a date format of dd/MM/yyyy or dd/mm/yyyy on their SQL servers were not able to connect due to a license file violation. SQL Agent Insight will throw the following error dialog,”It appears that the SQL server’s date is greater than the Expiry date specified in the license file”. SQL Agent Insight will not monitor a SQL server if the date of the server is out-of-bounds of the license.
    Short date formats tested include the following:
  • dd/MM/yyyy; dd/mm/yyyy

Version 0.8.5044.0 (released: November 24, 2013) - Click to Expand

New Features

  • Agent Job Monitor – the ability to script a single job, all jobs on a monitored server, or all filtered jobs.
    • Options to save to clipboard and/or save to file.
    • This feature uses SMO (SQL Server Management Objects), see System Requirements for download links direct from Microsoft for these requirements).
  • Job Conflict Summary
    • Select all jobs that conflict with a given job, all jobs using the same schedule, or all jobs with conflicts.

Improvements

  • Job Conflict Summary
    • The ability to filter/show only filtered jobs.
    • Average job runtime and maximum job runtime in hh:mm:ss format. Previously this was shown in ‘seconds’ which made it harder to calculate how long the job ran.
  • Agent Job Monitor
    • New user interface for easier job filtering.
    • Additional columns showing created and modified date of each job.
  • New binary assembly numbering
    • Primary builds will have a zero (0) in the revision column (e.g. 0.8.5044.0)
    • Secondary or bug fix builds will have a non-zero in the revision column (e.g. 0.8.5044.5142)

Bug Fixes

  • Minor bug fixes.

Version 0.7.4993.38253 (released: September 3, 2013) - Click to Expand

New Features

  • None

Improvements

  • None

Bug Fixes

  • The license file can now be read correctly if the user’s system short date contains a text representation of the month or the day, e.g. Tuesday, September 3, 2013.
    Short date formats tested include the following:
  • MM/dd/yyyy; MM-dd-yyyy
  • M/d/yyyy; M-d-yyyy
  • M/d/yy; M-d-yy
  • MM/dd/yy; MM-dd-yy
  • yy/MM/dd; yy-MM-dd
  • yyyy-MM-dd
  • dd-MMM-yy
  • MMM dd yyyy; MMM-dd-yyyy
  • MMMMM dd, yyyy; MMMM dd, yyyy; MMMM d, yyyy
  • dddd, MMMM d, yyyy

Version 0.7.4940.40409 (released: July 12, 2013) - Click to Expand

New Features

  • None

Improvements

  • Email notifications now have the ability to use SSL/TLS via a checkbox in the Configuration dialog.
  • Sending a test email now uses a background worker thread so that the UI does not become unresponsive while attempting to connect to the configured SMTP server.
  • All Insight email notifications (if configured) will use background worker threads to send emails without making the Insight wait until send completion.

Bug Fixes

  • Send test email button in Configuration dialog wasn’t working 100%.
  • Email notifications now aware of SMTP port configuration. It was previously being ignored.

Version 0.7.4937.29832 (released: July 10, 2013) - Click to Expand

New Features

  • Officially verified to work with SQL Server 2012!
  • SQL Server 2012 systems are enumerated on the network.
  • Ability to override the application name. Useful if the DBA wants to better cloak SQL Agent Insight from appearing in the SQL Server processes view.
  • Pause polling button for each Insight with the ability to resume at the previous configured polling interval.
  • List running jobs button logs to Insight Log tab all running jobs during active poll.
  • Option to minimize all active Insights to a scorecard view showing a summary of all monitored metrics and their status, either critical, warning, ok, or in maintenance. Valuable when monitoring multiple instances of SQL Agent.
  • Recently connected servers list. Automatically saves to file on changing of the list.
  • Option in main configuration to hide program from taskbar when SQL Agent Insight in minimized.
  • The ability to set the critical and warning thresholds based on the most recently polled values.

Improvements

  • Additional tool tips throughout the software explaining metrics and buttons.
  • Better threshold alarm logging to log tab. Previous logging was a little cryptic. Also includes date/time stamp for all actions done in logging window.
  • Refined user interface – consistent form fonts, better color scheme, along with a more professional feel to the toolbar rendering method.
  • Enumerated and recent server lists are now being populated in the ‘New’ connection dialog dropdown.

Bug Fixes

  • Agent Job Monitor – auto refresh now works as intended. Previously if nothing was selected in the dropdown, an error would occur, and refreshing would not honor the selected value.
  • Configuration dialog – when clicking on the ‘Write Events to Application Log’ checkbox, the ‘Apply’ button would not come active, therefore ignoring the setting. This has been resolved.
  • Changing the polling period while in a manual polling state to another interval would not indicate the correct value for the status of the monitored agent. This has been resolved in this build.
  • Some threshold configuration limits (Total Log Events and Total Log Errors) were unreasonably low for an actual monitored production system. This limit has been increased.

Version 0.6.4690.19204 (released: November 3, 2012) - Click to Expand

New Features

  • None

Improvements

  • None

Bug Fixes

  • Connecting to a SQL named instance would fail and would only connect to the root instance on the machine in question. Named instances can now be monitored with this release.

Version 0.6.4642.35879 (released: September 24, 2012) - Click to Expand

New Features

  • Job Conflict Summary – visually see which jobs conflict with other scheduled jobs, 3, 5 and 7 days into the future, right down to the second.

Improvements

  • Minor interface appearance tweaks.
  • There is now an option to turn on/off logging to the application event log, thus not showing “Run as Administrator” dialog if toggled off. (Set in Configuration dialog)

Bug Fixes

  • An error would occur while polling the database mail metrics, causing the Insight to revert to manual polling mode.
  • Agent Job Monitor – jobs with runtimes between midnight and noon were parsed incorrectly, not showing the correct time of day.

Version 0.5.4436.41566 (released: February 24, 2012) - Click to Expand

New Features

  • None

Improvements

  • None

Bug Fixes


Version 0.4.4376.42122 (released: December 26, 2011) - Click to Expand

New Features

  • Application Event Logging (requires local Administrator access rights)
  • No expiry trial license.

Improvements

  • None

Bug Fixes

  • Minor bug fixes.

Version 0.3.4203.40911 (released: July 24, 2011) - Click to Expand

New Features

  • Confirmed working with SQL Server 2008 R2.
  • Agent Job Monitor view
    • Shows all jobs with easily identifiable states including disabled and currently executing.
    • Quickly identify jobs without schedules, notifications, or steps.
    • Allows for filtering and auto refresh.
  • Clickable job metrics allowing deeper investigation into configured thresholds.

Improvements

  • None

Bug Fixes

  • Minor bug fixes.

Version 0.2.3992.37600 (released: December 10, 2010) - Click to Expand

New Features

  • Global e-mail notifications.
  • E-mail notification suppression for individual insights.
  • Selective threshold monitoring.
  • Additional polling intervals (5, 10, 15, 30 and 60 minutes).
  • More detailed insight logging.

Improvements

  • Minor interface layout changes.

Bug Fixes

  • Minor bug fixes.

Version 0.1.3768.38938 (released: April 20, 2010) - Click to Expand

New Features

  • Initial product. Enjoy!