New release: SQL Monitor Version 12.0 is now available. Read more.

SQL Monitor 12 Released

Greg_SmulkoGreg_Smulko Posts: 30 Silver 1
edited October 29, 2021 1:06PM in SQL Monitor
SQL Monitor 12.0.0 has been released. Direct download link.

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 | Software Engineer | Redgate Software

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 | Software Engineer | 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 | Software Engineer | 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: 2 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: 16 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
Sign In or Register to comment.