Features

• Added new metrics to analysis tab:
  • Page reads/sec.
  • Free list stalls/sec.
• Improved support aliases in machine-level alert details.

Fixes

• Change wording of "server" to "instance" in the Set Alias dialog.
• Fixed stack overflow exception in SQL Monitor related to calculation of a chain of blocked SQL Server processes.

Fixes

• An issue that could cause a foreign key conflict on upgrade has been fixed.

Features

• Added a new alert type - Configuration change which is raised when server configuration options change.

Fixes

• The instances affected list on the alerts page now displays (local) rather than empty for default instances.
• Prevent crash when reading OpenId Connect config from Credential Manager fails.

Features

• 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

• Fixed deadlock XDLs being downloaded in an incorrect format.

Features

• Improved performance when the website accesses a clustered base monitor service running in multiple subnets.
• Disabled webhook notifications in alert configuration.

Fixes

• Fixed overly large memory grants in SQL Process sampler.
• Fixed 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.

Fixes

• Fixed a regression causing report PDF generation and emailing to fail.
• Fixed issue sampling top queries when upgrading directly from versions of SQL Monitor older than 11.0.16.

Features

• Added remove instance option to unreachable instances on monitored servers page.

Fixes

• Fixed long running query alerts for Azure Managed Instance in timezones different from UTC.

Fixes

• Fixed regression of invalid spacing between inputs.

Features

• You can now edit the Microsoft 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.

Features

• Exposed 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.
• Fixed regression to allow specifying multiple target addresses for SNMP notifications.

Features

• Added Microsoft SQL Server Metrics to Microsoft Azure SQL Managed Instance overview page.
• You can now edit 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.

Features

• Microsoft SQL Server configuration options estate page: Added the ability to inspect SQL Server configuration options and visualize configuration variance across your monitored instances.
• Accounts used to monitor SQL Server instances no longer require 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.

Features

• Microsoft 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.
• 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.
• SQL Monitor no longer supports "legacy" (pre-Chromium versions) of Microsoft Edge, now that Microsoft has dropped support for it.

Fixes

• 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.
• 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.