Comments
88 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'.
-
jeremiahpeschka said:mykaska said:Installed the version 11.0.17
getting tons of error in SQL Server logs
Invalid object name '##redgate_sqlmonitor_querywaitstats_isHGwi__Q1ijH1tSYJA1UVK0ya4s'.
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.
-
DonFerguson said: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.
-
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 linkFixes
- 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 linkFeatures
- 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 linkFeatures
- SRP-13623 Added Deadlock report tile
Fixes
- Fix escaping error in
SqlDatabaseFileSampler
andSqlDatabaseStorageSampler
- 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.
-
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
andSqlDatabaseStorageSampler
- 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.
-
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.
-
Awesome! Thanks for adding the line breaks. Very useful!
-
Version 11.1.0 has been released
Direct download linkMajor 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.
- SQL Monitor no longer supports "legacy" (pre-Chromium versions) of Edge, now that Microsoft has dropped support for it.
-
Version 11.1.1 has been released
Direct download linkFeatures
- 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 linkFeatures
- 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 linkImprovements
- 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.
- 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
-
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
-
Version 11.1.4 - April 15, 2021
Direct download linkImprovements
- 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.
-
Version 11.1.5 - April 22, 2021
Direct download linkFixes
- Fix regression of invalid spacing between inputs.
-
Version 11.1.6 - April 29, 2021
Direct download linkFeatures
- 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 linkFixes
- 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
-
Version 11.1.8 - May 13, 2021
Direct download linkFeatures
- Improved performance when the website accesses a clustered base monitor service running in multiple subnets (see https://documentation.red-gate.com/display/SM11/Installing+SQL+Monitor+with+High+Availability).
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.
-
Version 11.1.9 has been released
Direct download linkImprovements
- 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.
-
the download link for 11.1.9 does not work
-
It's missing the.exe from the end of the download link
-
Thank you both for pointing this out! Apologies, link now fixed.
-
Version 11.1.12 has been released
Direct download linkImprovements
- 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.
-
Version 11.2.0 has been released
Direct download linkImprovements
- 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.
-
Add comment
Please sign in to leave a comment.
Attend a training webinar to discover what's new in SQL Monitor 11.
Major changes
Features
Improvements
Fixes
Changes