How do you use cloud databases? Take the survey.

SQL Monitor 11 Released

2

Comments

  • mykaska said:
    Installed the version 11.0.17
    getting tons of error in SQL Server logs
    Invalid object name '##redgate_sqlmonitor_querywaitstats_isHGwi__Q1ijH1tSYJA1UVK0ya4s'.
    Hey! If you open up a support ticket, they should be able to diagnose this and get you sorted out.
  • mykaskamykaska Posts: 19 Bronze 2
    mykaska said:
    Installed the version 11.0.17
    getting tons of error in SQL Server logs
    Invalid object name '##redgate_sqlmonitor_querywaitstats_isHGwi__Q1ijH1tSYJA1UVK0ya4s'.
    Hey! If you open up a support ticket, they should be able to diagnose this and get you sorted out.

    Request #245886

  • So after installing 11.0.17 my Global Overviews is painted with red monitoring errors.  It seems that this is a bad release.  I recommend that everyone hold off in this update until it's fixed.
  • mykaskamykaska Posts: 19 Bronze 2
    So after installing 11.0.17 my Global Overviews is painted with red monitoring errors.  It seems that this is a bad release.  I recommend that everyone hold off in this update until it's fixed.
    yeah, i had to reconnect a few instances manually
  • That doesn't seem to be working for me this time.  I will go ahead and submit a support ticket with logs.  I may need to roll this one back.
  • Version 11.0.18 has been released

    Direct download link

    Fixes

    • SRP-13584 Stored procedure parent sampling enabled on Azure Sql Server
  • Much better!  Thanks for fixing the 11.0.17 issue quickly.
  • Version 11.0.19 has been released

    Direct download link

    Features

    • Added CPU and disk metrics for Azure SQL Managed Instances in the global dashboard and server overview page graphs.
    • Enabled processor utilisation and low disk alerts for Azure SQL Managed Instances.
    • Add Azure SQL Managed Instance metrics to the analysis page.

    Note: Azure Managed SQL Instance support is still in preview

    Improvements

    • Improve error messages on the notification settings page
    • SRP-13547 Stop querying non-readable secondary Availability Group replicas
    • Improved diagnostic logging. All failing RPC calls from the website to the base monitors are now logged by the base-monitor, and include extended error data.

    Fixes

    • SRP-13596 Interval CPU % shows an average of the cpu usage instead of the last available value.
    • SRP-13579 The interval for the zoom window on the server overview page stopped growing after a refresh
    • SRP-13569 Alert inbox counts not updating problem potentially fixed
    • ZD-246059 Unreachable alerts are no longer incorrectly raised when monitoring is suspended.
    • Fixed an issue with AG where a casing mismatch prevents data collection
    • SRP-13598 AG Overview page shows correct databases when there is a casing mismatch
    • SRP-13617 Display aliases for instances on grouped alerts related to a secondary base monitor
    • Fixed an issue that occasionally caused the server overview page to fail to display data in a multi base monitor setup
    • ZD-245505, ZD-246176 Fix escaping error in StoredProcedureParentSampler
  • Version 11.0.20 has been released

    Direct download link

    Features

    • SRP-13623 Added Deadlock report tile

    Fixes

    • Fix escaping error in SqlDatabaseFileSampler and SqlDatabaseStorageSampler
    • SRP-13609 The AD API now automatically grants access to all entities for newly added administrators
    • Fixed a sampling error for Azure SQL Managed Instance CPU and Disk metrics that caused gaps in the sampled data.
    Naz Yilmaz | Software Engineer | Redgate Software
  • Version 11.0.21 has been released


    Features

    • Added PowerShell API support for Azure SQL Managed Instances, including alert settings configuration.
    • Additional SQL Server configuration options are displayed on the server overview. Configuration
      can be compared across different instances.

    Improvements

    • Added spinners on the tempDB section that are displayed when the data is being loaded.
    • SRP-13629 changed the settings on database file usage alert to consider autogrowth and maximum file size. Alerts that have been set to be disabled when autogrowth is enabled will now start alerting if the database has a maximum file size set.
    • Ignore the following waits: RESOURCE_GOVERNOR_IDLE, WAIT_XTP_OFFLINE_CKPT_NEW_LOG, PVS_PREALLOCATE, HADR_FABRIC_CALLBACK, PWAIT_EXTENSIBILITY_CLEANUP_TASK.

    Fixes

    • Fix escaping error in SqlDatabaseFileSampler and SqlDatabaseStorageSampler
    • SRP-13610 The active directory API now accepts principal names in mixed case
    • SRP-13625 Fix regression of ignoring clock display settings in the Alerts Group Details page.
    • Z246544 Fix regression of not showing query text for blocking processes.
    • Resolves an issue with unreachable alerts being erroneously raised immediately after the base service is restarted.
    • Z244488 Improves reliability sampling SQL Server process utilization after a failover.
    • Version 11.0.19 contained a fix for a security vulnerability that affected access control for non-administrator users when Active Directory authentication is enabled. See https://www.red-gate.com/privacy-and-security/vulnerabilities/2021-02-24-sql-monitor for details.
    • SRP-13626 Reports will be generated when the website is not open.

    Software developer
    Redgate Software
  • Version 11.0.22 has been released

    Improvements

    • Session query text on server overview pages maintain line breaks

    Fixes

    • Z247330 and Z247103 Fixed Backups page loading blank.
  • DonFergusonDonFerguson Posts: 196 Silver 5
    Awesome!  Thanks for adding the line breaks.  Very useful!
  • Chris LambrouChris Lambrou Posts: 25 Bronze 3
    edited March 18, 2021 12:59PM

    Version 11.1.0 has been released

    Direct download link

    Major changes

    • SQL Monitor no longer supports "legacy" (pre-Chromium versions) of Edge, now that Microsoft has dropped support for it.

    Features

    • Azure SQL Managed Instance monitoring support is now out of preview and is fully supported. Each monitored instance will now consume one license.
    • Global dashboard now has a better 'single pane of glass' view with the ability to group by the status of instance (based on alert severity). Additionally these sections are collapsible.

    Improvements

    • Affected SQL Instances list on machine unreachable alert made clickable to access respective server overview pages of the instances.
    • Added support for the "Deadlock (extended event)" alert on Azure Managed Instances.

    Fixes

    • CVE-2021-27516 Updated the urijs package to 1.19.6 to address a reported vulnerability. The vulnerability has a CVSS score of 7.5 (High), but SQL Monitor's use of this library meant that it was not subject to the vulnerability. See https://www.npmjs.com/advisories/1640 for more details.
    • Fixed an issue that could cause the global dashboard to display an error when an alert was raised on an Azure Managed Instance added with the hostname,port format.
    • Fixed an issue in the PowerShell module where JSend responses from SQL Monitor were being incorrectly processed if the results of an API call were empty.
    • Fixed healthy status for Amazon RDS SQL Server instances in the global dashboard for unreachable instances.
    • An issue that could cause database file usage alerts to be incorrectly raised for databases with autogrowth enabled has been fixed.
    • The deadlock report tile can now be restricted by cluster node, using the "For:" picker on the report.
    • System databases excluded from stored procedure sampling as it was causing permission errors.
    • Fixed an issue with SQL Server error 40613 incorrectly being classified as an authorization error.
    • Fixed issue on disk usage estate page showing incorrect values when filters are changed rapidly.
    • Fixed an issue where an alert on a specific SQL Server instance inside a cluster could also appear on other cards for that cluster on the Global dashboard.
    Chris Lambrou
    Software Engineer, SQL Monitor Team
  • Version 11.1.1 has been released

    Direct download link

    Features

    • SQL Server configuration options estate page: Inspect SQL Server configuration options and visualize configuration variance across your monitored instances.

    Improvements

    • Removed the requirement for the account used to monitor SQL Server instance to have the db_ddladmin role for the sys.dm_db_index_physical_stats query

    Fixes

    • Fixes "Server configuration options" on server overview pages showing as blank until the zoom range is changed.
    • An issue that could cause an error accessing the Azure SQL Database overview page has been fixed

  • Version 11.1.1 has been released

    Direct download link

    Features

    • SQL Server configuration options estate page: Inspect SQL Server configuration options and visualize configuration variance across your monitored instances.

    Improvements

    • Removed the requirement for the account used to monitor SQL Server instance to have the db_ddladmin role for the sys.dm_db_index_physical_stats query

    Fixes

    • Fixes "Server configuration options" on server overview pages showing as blank until the zoom range is changed.
    • An issue that could cause an error accessing the Azure SQL Database overview page has been fixed

  • Version 11.1.2 has been released

    Direct download link

    Improvements

    • Added SQL Server Metrics to Azure SQL Managed Instance overview page
    • You can now edit the SQL Server Connection Properties when adding an Azure SQL Managed Instance

    Fixes

    • Fixed an issue with long queries on server overview pages not being scrollable
    • Fixed an issue with error logs and permissions failing to load for default named instances
    • Fixed an issue with alerts in sub-groups not being displayed when the top-level groups are selected
    • Fixed an issue with major version upgrades when base monitor and web frontend are installed separately
  • Version 11.1.3 has been released

    Direct download link

    Improvements
    • Expose thumbprint if the web server isn't authorized to access base monitor.
    Fixes
    • Stops sampling the snapshot databases that were causing errors to be logged in SQL Profiler
    • Do not generate reports with a disabled schedule
    • Resolves issue with estate pages failing to display after a failed request to get data
    • Fix regression to allow specifying multiple target addresses for SNMP notifications
  • RoseannaRoseanna Posts: 353 Rose Gold 3

    Do you have any questions about v11.1 or SQL Monitor in general?

    Product Manager Maxime Drobot and Tech Lead Maya Malakova are online now to answer your questions!

    Ask your question here

    Product Marketing Manager for SQL Prompt and SQL Toolbelt Essentials
  • Version 11.1.4 - April 15, 2021

    Direct download link

    Improvements

    • You can now edit the SQL Server Connection Properties when adding an Amazon RDS SQL Server.

    Fixes

    • A bug that caused the test button on the Monitored Servers page to incorrectly report failures for failover cluster instances has been fixed.
    • transaction version storage space usage will sample from SQL Server 2016 SP2 version rather than being disabled until SQL Server 2017.
    • Immediately stop displaying cards for removed instances on the global dashboard.
    • Fixed an issue with Azure Sql Databases showing duplicate cards on Global Dashboard.
    Chris Lambrou
    Software Engineer, SQL Monitor Team
  • Version 11.1.5 - April 22, 2021

    Direct download link

    Fixes

    • Fix regression of invalid spacing between inputs.
  • AzizAziz Posts: 9 New member

    Version 11.1.6 - April 29, 2021

    Direct download link

    Features

    • Remove instance option added to unreachable instances on monitored servers page.

    Fixes

    • Fix long-running query alerts for Azure Managed Instance in timezones different from UTC.
  • Version 11.1.7 - May 4, 2021

    Direct download link

    Fixes

    • Fixes a regression causing report PDF generation and emailing to fail.
    • Fixes issue sampling top queries when upgrading directly from versions of SQL Monitor older than 11.0.16
    Software Engineer
    Redgate Software
  • Version 11.1.8 - May 13, 2021

    Direct download link

    Features

    Improvements

    • Disable webhook notifications in alert configuration.

    Fixes

    • Fixes overly large memory grants in SQL Process sampler.
    • Fixes admin access not being correctly applied when using basic authentication.
    • Fixed an error monitoring Azure SQL Managed instances in the business critical or premium tier.


  • GeoffSimonsGeoffSimons Posts: 27 Bronze 2
    edited May 20, 2021 2:54PM

    Version 11.1.9 has been released

    Direct download link

    Improvements

    • The deadlock report tile can now be filtered by SQL Server.
    • The alert configuration table now shows if webhooks are enabled for each alert type.

    Fixes

    • Fix deadlock XDLs being downloaded in an incorrect format.
  • mykaskamykaska Posts: 19 Bronze 2
    the download link for 11.1.9 does not work
  • JonnyGJonnyG Posts: 8 New member
    edited May 20, 2021 2:20PM
    It's missing the.exe from the end of the download link  8-)
  • Thank you both for pointing this out! Apologies, link now fixed.
  • joshcrangjoshcrang Posts: 21 Bronze 2
    edited June 10, 2021 12:52PM

    Version 11.1.12 has been released

    Direct download link

    Improvements

    • Added new metrics to analysis tab: Page reads/sec; and Free list stalls/sec
    • Support aliases in a list of affected instances of a machine-level alert details.

    Fixes

    • Change wording of "server" to "instance" in the Set Alias dialog.
    • Fix stack overflow exception in SQL Monitor related to calculation of a chain of blocked SQL Server processes.
    Software Engineer
    Redgate Software
  • Matthew_ChappelowMatthew_Chappelow Posts: 19 Bronze 2
    edited June 18, 2021 11:09AM

    Version 11.2.0 has been released

    Direct download link

    Improvements

    • OpenID Connect (OIDC) as a new authentication type (in addition to Basic and Active Directory).
    • Preview: SQL Server instance discovery. Automatically discover SQL Server instances on your estate and start monitoring them.

    Fixes

    • Fixed escaping of logged in user name.
    • Fix Error Severity 21 when sampling for DatabaseConfigurationOptions (No use of Snapshot Databases).
    • Links from custom metric alerts to the analysis page correctly select the appropriate custom metric.



  • DevendraSinghDevendraSingh Posts: 16 Bronze 1
    edited June 18, 2021 6:25AM
    @Mathew, How can we have two release with same build?  ;‑]

    Downloaded the setup and realised it was 11.2 :)
Sign In or Register to comment.