How do you use cloud databases? Take the survey.

SQL Monitor 12 Released

Greg_SmulkoGreg_Smulko Posts: 41 Silver 1
edited March 14, 2022 2:30PM in Redgate Monitor
We decided to stop posting updates about new releases on this forum.
Please rely on in-product notifications about new versions or keep monitoring the release notes page.
You can always download the latest version.



SQL Monitor 12.0.0 has been released.

Major changes

  • Introduced a new permit-based licensing system, fully supporting the new SQL Monitor subscription offering.
  • The search bar for Top Queries is now out of preview.
  • The SQL Server Configuration Options Estate page is now out of preview.
  • Migrated the SQL Monitor website to ASP.NET Core 5.
  • Monitoring of SQL Server 2005 is no longer supported.

Fixes

  • Do not apply UTC recalculations for dates in graphs.
  • A bug that prevented indexing for top queries search on Azure SQL Managed Instances and Amazon RDS SQL Server instances has been fixed.
  • Fix the email title with the correct group.
  • Handle errors when Registry Provider is not found.
  • Changed the samplers deadlock priority, which should stop the other processes from becoming victims.
  • Fix failover cluster instance display name.
Greg Smulko | Technical Architect for SQL Monitor | Redgate Software
«1

Comments

  • SQL Monitor 12.0.1 has been released. Direct download link.

    Fixes

    • ZD-260627 Fix issue where SQL Monitor stops monitoring Azure Managed Instances after an authorization error related to AG failover.
    • Fixed issue with export button in the Estate Configuration and Discovery pages for Amazon RDS and Azure Managed Instances.
    • Display more information for Azure Managed Instances and Amazon RDS on their version and edition on the Estate Configuration page.

    Software developer
    Redgate Software
  • SQL Monitor 12.0.2 has been released. Direct download link

    Fixes

    • Fix issue where offline activation of a permit fails.
    Greg Smulko | Technical Architect for SQL Monitor | Redgate Software
  • SQL Monitor 12.0.3 has been released. Direct download link

    Fixes

    • Allow Azure SQL database to be used as a repository for SQL Monitor in the installer when the user is not an administrator.
    • Fix regression where links are not rendered correctly on the Edit Alert page.

    Changes

    • Security: Delay and rate limit login attempts in case of too many invalid attempts.



  • SQL Monitor 12.0.4 has been released. Direct Download Link

    Features

    • Prevent update notifications for 7 days after installing or upgrading.
    • Added in product licensing permit expiry notifications.
    • You can now alias Azure SQL Managed Instances, Amazon RDS Servers and Azure SQL Databases

    Fixes

    • Fix issue where the Machine Unreachable alert is not raised for machines that are part of a cluster.
    • Fix issue where Amazon RDS API Credentials could not be updated.
    • Fix issue preventing the Deadlock alert configuration from being changed.
  • abhinavreddyabhinavreddy Posts: 4 New member
    edited November 11, 2021 10:51AM

    SQL Monitor 12.0.4 has been released. Direct download link

    Features

    • Prevent update notifications for 7 days after installing or upgrading.
    • Added in product licensing permit expiry notifications.
    • You can now alias Azure SQL Managed Instances, Amazon RDS Servers and Azure SQL Databases

    Fixes

    • Fix issue where the Machine Unreachable alert is not raised for machines that are part of a cluster.
    • Fix issue where Amazon RDS API Credentials could not be updated.
    • Fix issue preventing the Deadlock alert configuration from being changed.
  • SQL Monitor 12.0.4 has been released.  Direct Download Link

    Features

    • Prevent update notifications for 7 days after installing or upgrading.
    • Added in product licensing permit expiry notifications.
    • You can now alias Azure SQL Managed Instances, Amazon RDS Servers and Azure SQL Databases

    Fixes

    • Fix issue where the Machine Unreachable alert is not raised for machines that are part of a cluster.
    • Fix issue where Amazon RDS API Credentials could not be updated.
    • Fix issue preventing the Deadlock alert configuration from being changed.
  • SQL Monitor 12.0.5 has been released

    Direct download link

    Fixes

    • Fix memory leak in base monitor when clusters are monitored.
    • Fix invalid link to Transaction Locking and Row Versioning Guide in MSDN
    • Correct end of support date for SQL Server 2014.
    • Fix broken analysis graph links in availability group overview page.
    Greg Smulko | Technical Architect for SQL Monitor | Redgate Software
  • Version 12.0.6 has been released. Direct download link.

    Features
    • You can now view Current activity for queries from the Server overview.
    • Permit-based licensing support for multi-webserver installations.
    • You can now tag SQL Server instances, Azure SQL Databases, Azure Managed Instances and Amazon RDS instances on the Monitored Servers page and use these tags to filter the global dashboard.
    Fixes
    • A bug that prevented configuration of 2-8 alert types has been fixed.
    • A bug that prevented configuring alerts if no default e-mail address had been specified has been fixed.
    • Fixed aliases on the Global Dashboard when multiple base monitors are present.
    • Fixed a bug that prevented displaying of aliases in the Alert Inbox server tree when using multiple base monitor.
    Changes
    • Enabled error reporting by default. If you wish to disable sending information about exceptions to Redgate, it can be done from the Diagnostics section of the Configuration page.

  • SQL Monitor 12.0.7 has been released. Direct download link.

    Improvements

    • Improved usability of metrics on Analysis page. You can now filter the metrics and entities using a text box.

    Fixes

    • Fix error downloading report pdf for e-mail after upgrading to v. 12 when the "Fully qualified website URL" configured in Notification Settings has a trailing slash.
    Naz Yilmaz | Software Engineer | Redgate Software
  • SQL Monitor 12.0.8 has been released. Direct download link.

    Fixes

    SRP-14041 Fix internal SQL Monitor error caused by access to the SQL Monitor repository using monitoring credentials


    Software developer
    Redgate Software
  • SQL Monitor 12.0.9 has been released. Direct download link.

    Improvements

    • You can now use deadlock report tiles for Azure Managed Instances.
    • Security improvements relating to HTTPS, including the following: adding a Strict-Transport-Security HTTP header in all web requests; displaying a warning message when HTTPS is not in use; strengthened security on cookies; automatic redirection from HTTP to HTTPS.

    Fixes

    • Fixed highlighting of metrics/entities on Analysis page when selected.
    • Fixed a regression on creating an external custom metric.
    • Fixed an issue which could lead to plan cache bloat on monitored entities.
    • Fix error downloading report pdf for e-mail after upgrading to v. 12 when the "Fully qualified website URL" configured in Notification Settings has a trailing slash.
    • Avoid throwing an error for Trace file's deletion on the first attempt.

  • SQL Monitor 12.0.10 has been released. Direct download link.

    Improvements

    • Reduce the time to verify an unreachable monitored entity on the Current activity page.
    • You can now see Azure Managed Instances on summary report tiles.
    • Added an option to disable insecure TLS versions 1.0 and 1.1 via the appsettings.json config file.
    • SRP-14045 Removed `Server` and `X-Powered-By` from response headers.
    • You can now configure alerts for specific Jobs on Amazon RDS Sql Servers and Azure Managed Instances.
    • You can now configure alerts for specific Databases on Amazon RDS Sql Servers and Azure Managed Instances.

    Fixes

    • Fixed an issue where untagged/duplicate instances were shown randomly while filtering the global dashboard.
    • Fixed an issue where query history and top queries not showing data when a different base monitor is selected
  • SQL Monitor 12.0.11 has been released. Direct download link.

    Improvements

    • The Estate disk usage, backups and SQL Agent jobs pages can now be filtered by tag.

    Fixes

    • Fixed issue when disabling or inheriting configuration for multiple alert types when the alerts have different existing email configuration.
    • Fixed issue where newly added SQL Servers would not be correctly monitored until either the base monitor is restarted or "Retry connection" run from the monitored servers page.
    • Fixed issue when disabling or inheriting configuration for multiple alert types when the alerts have different existing email configuration.
    • Fixed issue when renaming report causes new report to be created.
    • Fixed issue on versions of IIS prior to IIS 10 (Server response header was re-added).
    Naz Yilmaz | Software Engineer | Redgate Software
  • LiamJonesLiamJones Posts: 4 New member
    edited January 6, 2022 9:25AM
    SQL Monitor 12.0.12 has been released. Direct download link.

    Improvements

    • Added advanced base monitor logging controls in the Diagnostics section

    Fixes

    • Fixes Edition filter on Server Licensing page resetting on refresh
    • Fixed a bug where some job failure alerts showed no jobs in "Details" > "Job runs during alert"
    • Fixed an issue where setting a preset time for a Analysis baseline would display time in the future
    • Fixed an issue with alerts not ending
    • Fixed an issue where standard or read-only users logging in using down-level format usernames are unable to see servers
    • Fixed an issue with the jobs estate pages sometimes showing data for previously used filters
    • Fixed an issue where Top waits graph was not being rendered

    • Fixes issue when removing cluster node with standalone instance orphans the SQL instance.

    Liam Jones | Software Engineer | Redgate Software
  • mykaskamykaska Posts: 19 Bronze 2
    @Liam, the direct download link is broken
  • SQL Monitor 12.0.13 has been released. Direct download link.

    Improvements

    • Provide option to remove requirement of db_owner permission on tempdb see docs here.

    Fixes

    • Fix a regression introduced in v.12.0.10 that causes Active Directory (AD) authentication to fail.
    • Prevent access to offline databases when sampling
    • Fix an issue where baseDn would be updated for all Active Directory domains
    • Fixed wrapping of SQL commands without spaces in deadlock visualizer
    • Fixed download of SNMP MIB file
    • Fixed PDF reports generation when data arrives slowly.
    • Fixed an issue where the Current Activity page would crash for a SQL Server instance without a display name
    • The plan cache size metric has been fixed to use the correct Perfmon counter
    • Fixed an issue where saving an empty channel in the Slack notification configuration would fail
    • Fixed a gradual memory leak in the Base Monitor's internal job scheduler.

    Changes

    • Alert emails now show source tags
    • Alert webhook notifications now include tags
    • Alert SNMP notifications now include tags
    Chris Lambrou
    Software Engineer, SQL Monitor Team
  • Jon_HJon_H Posts: 26 Bronze 1
    edited January 20, 2022 4:37PM
    SQL Monitor 12.0.14 has been released. Direct download link.

    Improvements

    • Provide option to remove requirement of db_owner permission on tempdb. See documentation here.
    • Adds a horizontal scroll bar to the left sidebar on the Alert settings page.
    • Display blocking processes tree on the Current Activity page.

    Fixes

    • An issue that could cause SQL Monitor to fail to reconnect to monitored servers after they are restarted has been fixed.


    Software developer
    Redgate Software
  • SQL Monitor 12.0.15 has been released. Direct download link.

    Improvements

    • View query plans on the Current Activity page.
    • Fixes an issue with admin users seeing "*** Redacted ***" in query plan parameters.
  • SQL Monitor 12.0.16 has been released. Direct download link.

    Features

    • Add version store usage alert.

    Fixes

    • Fixed an issue that caused wrong database name to show on deadlock alerts.
    • Fixes issues querying availability group replicas that disallow read-only connections when SQL Monitor has AvoidHadrDmvs is enabled.
    Liam Jones | Software Engineer | Redgate Software
  • We've pulled this release due to a regression on the alerts inbox page. Apologies to anyone affected.

    SQL Monitor 12.0.17 has been released. Direct download link.

    Features

    • Redesigned alert inbox with a fresh new look and support for tags.
    • The Current Activity page now supports Azure Managed Instances, Amazon RDS Sql Servers and Azure Sql Databases.

    Fixes

    • Fixed an issue where some timestamps were not correctly honouring the browser's local timezone offset, such as the occurrences in the alert details page.
    • Tags in Server Overview page can now successfully be removed from a server.

  • mykaskamykaska Posts: 19 Bronze 2
    edited February 10, 2022 2:51PM
    Well
    don't install 12.0.17 
    in alerts page button is broken

    both select and action buttons are showing the same menu

    you cannot clear alerts anymore


  • mykaska said:
    don't install 12.0.17 
    in alerts page button is broken
    Hey @mykaska, thanks for raising so quickly, we have now pulled the 12.0.17 release. 

    Liam
    Liam Jones | Software Engineer | Redgate Software
  • SQL Monitor 12.0.18 has been released. Direct download link.

    Fixes

    • Fixes an issue with the alert action menu in the alert inbox
  • Matthew_ChappelowMatthew_Chappelow Posts: 19 Bronze 2
    edited February 16, 2022 3:06PM

    SQL Monitor 12.1.0 has been released.

    Direct download link.

    Major changes

    • Tagging and filtering by tags is now out of preview.

    Features

    • Current activity feature is now out of preview, with full support for Azure MI, Azure SQL Server, Amazon RDS and SQL Server on prem.

    Fixes

    • Implemented Microsoft's Data Protection package to be used when SQL Monitor's website is behind a load balancer


  • RoseannaRoseanna Posts: 353 Rose Gold 3
    edited February 18, 2022 5:19PM
    Learn more about SQL Monitor's new features: tagging and the Current Activity page

    Tagging

    Everyone around you benefits if you’ve recorded basic things like what the server does and who is responsible for it, and we think that a great place to do this is in SQL Monitor.

    Our new tagging feature allows you to add useful labels on your SQL Server instances, Azure SQL Databases, Azure Managed Instances and AWS RDS instances. By introducing this into SQL Monitor, you have all the context you need when you come to investigate issues on the server.

    Read the blog

    Current Activity page

    This new tab shows you what is happening right now on your server. Quickly see blocked queries, slow queries that are still running, and more then act on them immediately to avoid them becoming bigger problems. 

    Read the blog

    Product Marketing Manager for SQL Prompt and SQL Toolbelt Essentials
  • I am finding both new features tagging and especially current activity extremely beneficial.  Nice work!  
  • RoseannaRoseanna Posts: 353 Rose Gold 3
    edited February 18, 2022 5:20PM
    This is great to hear. Thanks for sharing your feedback @DonFerguson! :) 
    Product Marketing Manager for SQL Prompt and SQL Toolbelt Essentials
  • MayaMalakovaMayaMalakova Posts: 14 Bronze 1
    edited February 24, 2022 2:03PM
    SQL Monitor 12.1.1 has been released. Direct download link.

    Features

    • SQL Monitor now knows if an Azure SQL managed instance is part of a failover group and provides information about the replication state of the instance. This feature is in preview and we would like to have your feedback in order to decide how to improve it. Learn more
    • Current Activity now supports filtering.

    Improvements

    • Decreased login time for SQL Monitor Admins when using Active Directory.
    • Added an option to specify if the ID token should be sent on logout requests through OpenID Connect
    • Various tweaks to the new alert inbox based on feedback
    • Improved behavior when in a narrow window
    • Clear and read are now top-level actions
    • Actions remain visible when scrolling through the inbox
    • Added an option to specify if the ID token should be sent on logout requests through OpenID Connect.

    Fixes

    • Fixed left navigation menu in alert inbox page not working when a SQL Server alias starts with multiple back slashes.
    • Improved the database backup sampler queries to address a performance regression in 12.0.12.
    • Fixed left navigation menu in alert inbox page not getting updated automatically.
    • Fixes an issue with "Older" and "Newer" buttons on the alert details page being disabled when not using the grouped alert inbox.
    • Fixes an issue where the icon for a job in the alert inbox was a question mark instead of a database icon.

    Changes

    • The Alert Inbox alert type multiselect now indicates when all alert types are selected, instead of the "x more" message.
  • SQL Monitor 12.1.2 has been released. Direct download link.

    Fixes

    • Sort order is correctly preserved when refreshing the Current Activity page.
      • Fixes an issue on the alert inbox where page size and the "group alerts" settings would be reset after following some links.
      • Fixes an issue where the Monitored Servers page would fail to load if the base monitor service account name contained certain special characters.
        • Fixes an issue where data retention settings would not show changes until saved.


      Sign In or Register to comment.