Features

• Session query text on server overview pages now maintain line breaks.

Fixes

• Fixed Backups page loading blank.

Features

• Added Microsoft PowerShell API support for Microsoft Azure SQL Managed Instances, including alert settings configuration.
• Additional Microsoft SQL Server configuration options are now displayed on the server overview. Configuration can be compared across different instances.
• Added spinners on the tempDB section that are displayed when data is being loaded.
• 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.
• Added the ability to ignore the following waits: RESOURCE_GOVERNOR_IDLE, WAIT_XTP_OFFLINE_CKPT_NEW_LOG, PVS_PREALLOCATE, HADR_FABRIC_CALLBACK and PWAIT_EXTENSIBILITY_CLEANUP_TASK.
• Improved reliability sampling SQL Server process utilization after a failover.

Fixes

• Fixed escaping error in SqlDatabaseFileSampler and SqlDatabaseStorageSampler.
• The active directory API now accepts principal names in mixed case.
• Fixed regression of ignoring clock display settings in the Alerts Group Details page.
• Fixed regression of not showing query text for blocking processes.
• Resolved an issue with unreachable alerts being erroneously raised immediately after the base service is restarted.
• 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.
• Reports will be generated when the website is not open.
• The Buffer Cache Hit Ratio metric is now no longer being collected and displayed.
• The installer of SQL Monitor is no longer bundled in the SQL Toolbelt installer. It is still part of the bundle from the licensing point of view and can be downloaded separately.

Features

• Added Deadlock report tile.

Fixes

• Fixed escaping error in SqlDatabaseFileSampler and SqlDatabaseStorageSampler.
• 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.

Features

• Added CPU and disk metrics for Microsoft Azure SQL Managed Instances in the global dashboard and server overview page graphs.
• Enabled processor utilization and low disk alerts for Azure SQL Managed Instances.
• Added Azure SQL Managed Instance metrics to the analysis page.
• Improved error messages on the notification settings page.
• Added the ability to 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

• Interval CPU percentage shows an average of the CPU usage instead of the last available value.
• The interval for the zoom window on the server overview page stopped growing after a refresh.
• Alert inbox counts not updating problem potentially fixed.
• Unreachable alerts are no longer incorrectly raised when monitoring is suspended.
• Fixed an issue with AG where a casing mismatch prevents data collection.
• AG Overview page shows correct databases when there is a casing mismatch.
• 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.
• Fixed escaping error in StoredProcedureParentSampler.
• Fixed an issue that could cause the Azure Managed Instance overview page to fail to display data in a multi base monitor setup.

Fixes

• Stored procedure parent sampling enabled on Azure SQL Server.

Features

• Added SQL Code Analysis integration:
  • Allows you to see all issues affecting a query in one place.
  • Allows you to raise issues relating to best practices, performance and deprecations.
  • Provides guidance on the effect of each issue and what you can do to resolve it.

Features

• Alerting now works on Microsoft Azure Managed SQL Instances.
• Azure Managed SQL Instances can now be organized in groups.
• You can now define Alert suppression windows for Azure Managed SQL Instances.
• You can now manage the permissions for accessing your monitored Azure Managed SQL Instances.
  • Note: Azure Managed SQL Instance support is still in preview and machine level metrics like CPU usage and memory are not monitored yet.

Fixes

• Display aliases for instances on any base monitor on alerts inbox and summary reports.
• Custom metrics now load correctly on the Analysis page for Amazon RDS and Azure Managed Instance servers.
• Redesigned list of affected instances for machine alerts.

Features

• Long running query alerts will now show executing stored procedure and potential caller procedures.
• Rewritten Global Dashboard to improve performance and responsiveness.

Fixes

• Minor fixes to the Global Dashboard.
• Fixed issue preventing integrity check overdue alert being raised.
• An issue that could cause the error log alert not to show the error description under certain circumstances has been fixed.
• Enforces a minimum size of 15 minutes for the zoom window on the Server Overview page.
• Fixed a mismatch between 'Instances with lowest uptime' summary tile on the Reports page and its saved PDF version.

Features

• Added group name validation for empty entries.
• Data settings: Improved support for performance features for base monitor repositories hosted on Microsoft Azure.
• Microsoft Active Directory authenticated users can now be configured through the API.

Fixes

• The latest occurrence column on the logon failure report tile now appears in local time.
• Ignore the 'Database is in transition' exception that is displayed as a connection error.
• An error that could cause Monitor to report "Multiple custom attributes of the same type found" on startup has been fixed.
• Fixed report PDF generating feature.
• Fixed rounding in tempdb graphs when the graph values ~< 5MB.

Fixes

• Fixed FCI node disappearing on monitored servers page, if there's only one node.
• Fixed broken link to server overview from suspended instances on the global dashboard.
• Fixed report PDF generating feature.

Features

• Pointer on hover over tempdb session table indicates that rows are clickable.

Fixes

• The session table rows in tempdb section are not collapsed while selecting SQL text.

Features

• Updated SNMP/Webhooks/Slack alert messages to display descriptions for custom alert types.
• The blocking process alert now reports the query start time, rather than the login time.
• Added tab to Alert Details showing which Microsoft SQL Server instances are affected by machine level alerts.

Fixes

• SRP-13553 Fixed a feature of expanding/collapsing of the entries in Top queries tab on Alert Details page

Features

• The preview of the reworked Microsoft Azure SQL Managed Instances support now includes an updated server overview page.

Fixes

• Estate disks page now shows failover cluster instances.
• Estate backups page now groups dbs with different casing but same name in an AG when using CI collation.

Features

• Added first preview of reworked support for monitoring Microsoft Azure SQL Managed Instances.
• New-SqlMonitorGroup, Remove-SqlMonitorGroup have been added to the API.
• Remove-SqlMonitorMachine and Get-SqlMonitorMachine have had pipeline support added in the API.

Fixes

• API cmdlet "Remove-SqlMonitorMachine" will now be able to remove standalone machines.

Features

• Explanatory text has been added to clarify a number of the graphs on the tempdb tab.

Fixes

• Fixed an issue that could cause the top of certain tempdb graphs to be incorrectly translated.
• Removed issue causing base monitor service user being incorrectly used to monitor servers occasionally.
• Fixed issue that fails to save product activation data to a file during manual activation.

Fixes

• Fixed an issue causing the Session Graph to not show data points.

Features

• Added detail page for Cluster Shared Volumes on Estate disk usage page.
• Job name and ID now available on long-running query alerts, if caused by a job.

Fixes

• Fixed an issue where some API requests fail due to SQL Monitor being hosted in an IIS subdirectory.
• Fixed an issue causing the SQL Instance unreachable alert to intermittently end and then immediately restart.
• Fixed appearance of new help menu that had an extra margin on a few pages.

Features

• Improved job sampler query to reduce load on monitored entities.
• Base Monitors can now be given a display name. Display names will show throughout SQL Monitor in place of the Base Monitor's network name.
• You can now add a group name to the alert notification emails by default.

Fixes

• Fixed disk space alert details page not loading for Amazon RDS instances.
• SQL Monitor will now only check active directory credentials once on login to avoid locking out users.
• Fixed an issue where the web installer crashed on the performance settings page.

Features

• Added the option to exclude SQL Agent job failed/cancelled alert on secondary AG nodes.
• Added the option to log alerts in the Microsoft Windows event log on the base monitor.
• Added the option to add a group name to the alert notification email.
• tempdb performance graphs now link to analysis page on click.
• Added database details in server overview page for Amazon RDS.
• Added test functionality to the Add Amazon RDS SQL Server page.

Fixes

• Fixed error adding Windows clusters that include the domain as part of their name.
• Standard User authorization issue on Estate - SQL Server Licensing Page.
• Fixed error when testing the base monitor inaccessible email when an SMTP password is set.

Fixes

• The option to add group name to the subject of email alert notification has been removed temporarily.
• Fixed JavaScript error when opening server overview for Amazon RDS instances without Enhanced Monitoring.
• Disable tempdb object sampler by default and remove from server overview page as it causes deadlocks.
• Fixed loss of some base monitor configuration on upgrade.
• Stop removing log files during uninstall, which sometimes caused the update to fail when SQL Monitor was running in IIS. The issue may be fixed not immediately but only after the next update.
• Fixes email alert notifications failing issue.

Features

• You can now add a group name to the subject of email alert notification.
• Added tempdb metrics to analysis page.

Fixes

• Fixed an issue that could cause upgrades to SQL Monitor 11 to fail.
• Fixed an issue that could cause internal SQL Monitor errors on TempDBObjects.
• Fixed TypeInitializerException when parsing amazon-rds-instance-classes.csv resource file caused by locale issue.

Features

• Amazon RDS support is now out of preview and is fully supported.
• tempdb monitoring with dedicated metrics and graphs is now out of preview.
• Added support for compressing the SQL Monitor data repository.
• Added highlighting session series when hovering over row in session table.
• Added Files section to tempdb on server overview.
• Changes to Active Directory configuration are immediately applied to all logged in users.
• Added support for Microsoft SQL Server performance settings (delayed durability, query optimizer hot fixes, batch mode for row store).
• Microsoft Internet Explorer 11 is no longer supported.

Fixes

• Fixed issue with blocking processes being raised on all databases on an Microsoft Azure Managed Instance.
• No longer populate the base monitor configuration when a website-only install is detected.
• Correctly scale units for sparklines on the server overview.
• The SQL recompilations/sec graph, which is displayed on certain types of alert, has been fixed.
• Resolves an issue where the backups estate page may fail to load.
• NaN value issue in the tooltip for the tempdb graphs has been fixed.
• Rescaling on tempdb tables graph has been fixed.