SQL Performance Suite - includes SQL Diagnostic Manager for SQL Server v12.2
Released: Oct 4, 2022
SQL Diagnostic Manager for SQL Server v12.2 での更新項目
機能
- SQL Diagnostic Manager now includes a brand-new browser interface framework called SQLDM Web Console which offers:
- Highly responsive user experience.
- Light Mode and Dark Mode options.
- Context-Aware Interface for Mobile and Tablet support.
- Simplified single-product focus built on a common design.
- Flexible design to easily update third-party components.
- Consolidated interface gathering together SQLDM Mobile, SQLDM IDERA Dashboard and Microsoft Windows Client.
不具合の修正
- Reports
- The Top Servers by Percent Usage report correctly displays CPU SQL Usage (Percent) values.
- SQL Diagnostic Manager now successfully exports the Plan XML (Estimated) report from the Event Occurrences detail view.
- The Server Uptime report pops up a "Select SQL Server" message when you do not select a server, otherwise, it works as expected.
- SQL Diagnostic Manager correctly gathers, stores, and reports Database Statistics.
- SQL Diagnostic Manager 12.2 correctly generates the Enterprise Summary reports including the SQL Server version of your instances.
- The Database Growth Forecast report is correctly generated.
- The Disk Space History report correctly lists the disk available on the monitored instances.
- The Disk Space History report is correctly generated for seven, 15, and 30 days.
- The Transaction Log statistics successfully return historical data.
- Alerts
- SQL Diagnostic Manager 12.2 correctly triggers email notifications for Database Full (Percent) and Filegroup Full Space (Percent) alerts.
- SQL Diagnostic Manager 12.2 successfully triggers email notifications for Log Full (Percent) alerts.
- The Blocked Sessions alert is successfully triggered in the configured response alert time.
- SQL Diagnostic Manager successfully triggers the Unsubscribed Transactions (Seconds) alert once is configured and enabled.
- The CPU Statistics report correctly shows trends for CPU usage, displaying the correct values for the CPUActivityPercentange alert.
- SQL Diagnostic Manager allows you to clear the recommendation alerts from the Alert Recommendation window until it raises again.
- SQL Diagnostic Manager allows you to snooze operational alerts but not clear them from recommendations.
- The Alert Configuration timeout value has been changed to get better performance.
- SQL Diagnostic Manager now correctly generates Blocking alerts and reports.
- SQL Diagnostic Manager correctly excludes databases from the Days Since Last Backup metric when exclusions are defined.
- SQL Diagnostic Manager correctly monitors the status of the DTC service.
- SQL Diagnostic Manager dismisses Availability Group Role Change alerts correctly.
- General
- SQL Diagnostic Manager no longer generates the "Unhandled exception: SplitterDistance must be between Panel1MinSize and Width - Panel2MinSize" when using the desktop client under certain screen resolutions.
- DM Console
- Users can now successfully add an existing user from one cluster to another while maintaining the original security settings.
- SQL Diagnostic Manager allows you to correctly check the licensed SQL Server instances in the Manage Servers window.
- SQL Diagnostic Manager console works as expected with more than 100 servers registered.
- SQL Diagnostic Manager can now successfully enable/disable Maintenance modes using Tags.
- The Tags view displays data with more than 100 created tags.
- The Add Server Wizard now saves the Query Monitor settings when the SQL Server instance is added.
- SQL Diagnostic Manager 12.2 successfully connects to monitored SQL servers after the KB5004442 Microsoft patch has been applied.
- The SQL Diagnostic Manager Management Service no longer crashes when there are more than one SNMP action provider configured.
- SQL Diagnostic Manager 12.2 response time has been improved.
- SQL Diagnostic Manager's recommendation engine has been updated to include additional recommendations found in SQL Doctor.
- The SQL Diagnostic Manager repository database now supports 2012 and higher compatibility levels.
- SQL Diagnostic Manager correctly displays the session status of ROLLBACK after a session is killed.
- Disks
- SQL Diagnostic Manager now successfully displays Disk Activity information for cluster shared volume drives (CSVFS) databases.
- Table
- SQL Diagnostic Manager correctly populates the list of mount points on the monitored instances.
- Analysis
- You can now successfully perform the Analysis Status of Azure instances.
- Services
- SQL Diagnostic Manager services perform successfully, making it possible that the Aggregation and Grooming jobs to work as expected.
- High Availability Groups
- The Long Send Rate (KB/s) metric now works as expected in High Availability Groups.
- The Availability Group History browser successfully displays the replica role status on particular instances.
- Upgrade
- The user can successfully add a new user after upgrading SQL Diagnostic Manager.
- DBaaS
- SQL Diagnostic Manager no longer generates sys.availability_group_listeners errors when monitoring Azure SQL Databases.
- Forecast alerts are successfully generated for Azure Manage Instance and Azure SQL Databases.
- Metrics
- SQL Diagnostic Manager correctly reports the correct values for the SQL Server Usage (Percent) metric.
- SQL Memory Usage metric correctly calculates the percentage of the total memory used by Azure SQL servers.
- SQL Server Agent Long Running Job (Percent) metric now provides the correct value.
- Queries
- SQL Diagnostic Manager correctly associates query data to the correct monitored instance.
- SQL Diagnostic Manager successfully gathers query data through Query Monitor on instances containing databases that have a trailing space in the database name.
- SQL Diagnostic Manager allows you to successfully refresh your data in any Query View.
- Users can now successfully configure the Query monitoring on any environment.
- SQL Diagnostic Manager successfully provides Query Plans. You can fetch them by clicking on the green icons of the Detail column of the Event Occurrences table.
- History Browser
- History Browser successfully changes the custom settings when moved to other servers.