SQL Monitor 8

SQL Monitor 8.0 Release Notes

 


When should I upgrade?

  • We aim to release a build every two weeks that includes the latest incremental features and bug fixes. These builds are identified by a three-part version number, such as v8.0.8. So if you’ve identified a particular feature from the release notes that you need, you can download the relevant build.
  • If you want to wait until all aspects of a feature have been fully completed, it’s best to use a quarterly minor version release, identified by a two-part version number such as v8.1.
  • Annual major releases (such as v8.0) combine multiple feature releases and undergo additional QA

Version 8.0.27 - January 23rd, 2019

Fixes

  • Fix Disk usage drill down failing to display data in limited situations

Version 8.0.26 - January 22nd, 2019

Features

  • Disk Usage now features drill down into individual disks, showing further details including usage for databases and files

Fixes

  • Some performance improvements to the Estates Backups and Jobs pages
  • SRP-11759 Event configuration fails when using windows impersonation

Version 8.0.25 - January 10th, 2019

Features

  • The Estate page for backups now handles AGs

Fixes

  • 122445 Allow searching by SQL Server instance name on the global dashboard
  • SRP-11665 Added more information to Head Blocker on blocking process tree
  • SRP-11664 Custom metrics contain "exclude databases" section
  • SRP-11704, SRP-11660 Parse Extended Events in the base monitor, logging any unexpected values
  • SRP-11101 Add copy query text to query plan view
  • 128691 Preserve formatting in long-running queries

Version 8.0.24 - December 11th, 2018

Features

  • Show query plan from Blocking processes tree. The query plan can now be viewed from within the Server Overview Blocking Processes tree.
  • Custom metrics can now be run against Azure SQL databases

Fixes

  • #126069 Fixed an issue where the alert details page would not respect the time format setting
  • #126314 The global dashboard would fail to display if you had Azure SQL databases with the same name on two servers
  • #127079 Fixed Custom Metric links from dashboard not working. Custom Metric alerts now appear separately from each other as different alert types
  • #126954 Fixed handling of special characters in group names in alert inbox server tree
  • SRP-11733 Fixed uncaught type error on alert details page

Version 8.0.23 - November 28th, 2018

Features

  • Integration with external backup tools. The Backups page highlights backups created by RedGate SQL Backup or another tool
  • More SQL Agent Jobs page improvements. The summary graph on the Jobs page now shows the number of successful and failed jobs over time and the job drill down shows the job duration history.
  • Databases inside elastic pools are no longer shown on global dashboard. Now they can be navigated from elastic pool card on Global Dashboard.

Fixes

  • SRP-11724 Fixed a bug that meant we were not generating backup overdue alerts based on the end-time of the latest backup
  • SRP-11560 12 hour clock is now supported on Analysis page
  • #122267 Fixed an issue with licensing on Windows Server Failover Clusters

Version 8.0.22 - November 13th, 2018

The licensing model for Azure SQL Databases has changed from requiring one full licence allocation per server to allowing five databases to be monitored per licence allocation.

Features

  • New alerts for Azure SQL Databases and Elastic pools for high worker thread and session utilization
  • Deadlock (XE) alerts can now be filtered by database, login name & resource, and victimless (eg Exchange Event) deadlocks are excluded by default
  • The summary graphs on the Installed Versions, Disk Usage, Backups and SQL Agent Jobs pages now can be filtered
  • Refinements to the display of recovery point objective (RPO) on the backups page, along with more information about the backups of each database - e.g maximum RPO and backup location

Fixes

  • #122267 Delay the initial licence check in case of cluster failover
  • #118799 Fixed an issue with authorization of a logged-in user when using multiple base monitors
  • #121086 Fixed an issue where custom metrics alerts may show with incorrect names when using multiple base monitors
  • SRP-11719 X-Frame-Options is now set in the web.config file

Version 8.0.21 - October 30th, 2018

Important

  • This upgrade contains a major enhancement to the implementation of Azure SQL Database to support Elastic Pools.

     Please note that while any previously added Azure SQL Servers will be migrated to the new implementation, any historical  data gathered in the previous beta implementation of this will be lost when data is purged.

Features

A new implementation of Azure SQL Database monitoring which will enable you to monitor Elastic Pools.

Version 8.0.20 - October 16th, 2018

Features

  • Preview - New Backup and SQL Agent Job pages have been added to the estate tab
  • Installed versions now shows GDRs as well as CUs and SPs

Fixes

  • Database File Usage alert for Filestreams has been fixed so that it only raises alerts if a max size is set
  • Excluded master database from Differential Backup Alerter, since Differential Backup cannot be performed on master

Version 8.0.19 - October 11th, 2018

Security fix

  • Resolves a security vulnerability whereby a logged-in-user who is tricked into visiting a malicious link or website can be forced to perform certain actions in SQL Monitor.

Fixes

  • Fix bug where backup overdue alerts were being raised incorrectly.

Version 8.0.18 - October 4th, 2018

Fixes

  • Fix bug where backup overdue alerts were being raised incorrectly.

Version 8.0.17 - September 19th, 2018

Fixes

  • Fixed a bug where low disc space alert displayed unknown for the space used
  • Fixed a bug with Export to (CSV) not working on the Analysis tab 

Version 8.0.16 - September 11th, 2018

Features

  • Added 14 days as an option to view reports
  • Filter Installed Versions by clicking pie chart
  • Support Installed Versions 2014 SP2 CU13 and 2017 RTM CU10

Fixes

  • Add IE 11 support for What's new release timeline
  • Fix DFU alerts firing when it is disabled when auto-growth is on
  • Fixed an issue where the sidebar on the alert inbox may fail to load

Version 8.0.15 - August 29th, 2018

Features

  • What's new release timeline: see features and fixes available in updates to SQL Monitor
  • Failover cluster instances are now displayed by their SQL Server network name, rather than Windows cluster name. Switching back to the previous behavior can be done in Configuration > Display settings.

Fixes

  • Fixes an issue sampling index fragmentation on some databases
  • Fixes an issue where low disk space alert may incorrectly associate database data files with a volume
  • Fixes an issue with data file usage alerts not being raised
  • Fixes an issue where the "Older" button on the alert details page may go to itself
  • Fixes an issue where tooltips on graphs may not hide correctly   

Version 8.0.14 - August 7th, 2018

Fixes

  • Fixes an issue with raising disk space alerts

Version 8.0.13 - July 26th, 2018

Fixes

  • Fixed an issue with alert details links on the global dashboard not working correctly

Version 8.0.12 - July 24th, 2018

Features

  • Added the ability to export the data from the Installed Versions page to Excel
  • Added the ability to export the data from the Disk Usage page to Excel

Fixes

  • Alert details page incorrectly shows times in UTC instead of browser-local time
  • Error message intermittently displays an incorrect error message on server overview page when loading data
  • Monitored servers page intermittently shows no servers when maintenance windows are configured
  • Top graph on server overview page doesn't show values on hover inside the selected interval
  • Performance improvements when loading alert counts in the alert inbox and when loading the global dashboard

Version 8.0.11 - July 16th, 2018

Fixes

  • Resolves an issue preventing read-only users from viewing reports

Version 8.0.10 - July 10th, 2018

Features

  • Redesigned purging configuration page: the purging configuration page has been redesigned to provide more information and the Performance diagnostics data category has been split in two
  • Added new Estate tab containing the new features "Installed Versions" and "Disk Capacity Planning"
  • Added "Comments" for alert configurations so that you can record why a configuration is setup a certain way
  • Make clock skew alert configurable
  • Update PowerShell API for adding instances using the SQL Monitor Web API

Fixes

  • Prevent installing the SQL Monitor repository to versions below SQL Server 2008 as this is minimum supported version, SQL Monitor continues to support the monitoring of SQL Server 2005 and above

Version 8.0.9 - June 12th, 2018

Features

  • Disk capacity planning (preview) - see historic, current, and projected disk usage across your estate

Fixes

  • The VMWare hosts configuration page now shows the configured VMWare hosts correctly
  • Improved the configuration page when working with Azure SQL DB servers and databases
  • Fixed an issue where Azure SQL DB servers may momentarily show as connected before failing

Version 8.0.8 - June 4th, 2018

Fixes

  • Prevent Unknown values appearing in some long running query and blocked process alerts when using a low alert threshold

Version 8.0.7 - May 31st, 2018

  • IMPORTANT  - The schema upgrade may take a few minutes due to population of the Alert  GroupCIR  column. This change significantly improves the performance of the Grouped Inbox.

Features

  • Installed Versions now shows the latest available Service Packs and Cumulative Updates for your estate
  • Differential backup overdue alert
  • Failed job report tile

Fixes

  • Fixes to Active Directory authentication


Version 8.0.6 - May 16th, 2018

Features

  • Alert types for high resource utilization on Azure SQL DB databases
  • Test button on monitored entities configuration page for Azure SQL DB
  • New data purge category has been added for storage data (e.g. Disk Capacity and Data File Size), allowing for data needed for usage projections to be stored for longer
  • Performance of the server overview page has been improved when the server has a large number of disks
  • The alert inbox now shows the duration of alerts when hovering over 'Last Updated' values


Version 8.0.5 - May 1st, 2018

Features

  • A new logon failures summary report tile
  • Information on space usage on the Data purging configuration page
  • Suspended instances now appear on the global dashboard

Fixes

  • This release contains a number of bug fixes for various issues reported to support.


Version 8.0.4 - April 18th, 2018

Features

  • Added option to increase number of queries viewed in top queries table

Fixes

  • Fixed an incorrect warning when alerting on database file usage for filestream files


Version 8.0.3 - April 9th, 2018

Features

  • Added a .xdl download for deadlocks when using extended events
  • Added wait time and wait resource when viewing a blocking session tree
  • Improved behavior of links throughout the application to allow use of browser features such as open in a new tab, or copy link address

Fixes

  • Improved memory consumption of the server overview page when run for extended periods of time with auto-refresh enabled
  • Auto-refresh on the server overview correctly persists page reloads
  • Server overview page correctly respects the time period when provided as a URL parameter
  • Fixed an issue where database file usage alerts may not be raised or be configurable


Version 8.0.2 - May 23rd, 2018 (re-release)


Version 8.0.2 - March 21st, 2018

Features

  • Grouped inbox for alerts

  • Support for Multiple Base Monitors
  • Support of Azure SQL DB (beta)
  • Blocking processes displayed as a tree
  • Query history displayed on the server overview page
  • A database file usage alert
  • Use Extended events to track deadlocks
  • Deployment integration with ReadyRoll and DLM Automation
  • Option to import multiple servers at once



Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?