SQL Management Suite

Complete SQL Server Monitoring Bundle.

Published by IDERA
Distributed by ComponentSource since 2013

Prices from: $ 6,169.10

Screenshot of SQL Management Suite

SQL Management Suite - includes SQL Diagnostic Manager for SQL Server v12.2

Released: Apr 19, 2023

Updates in SQL Diagnostic Manager for SQL Server v12.2

Features

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

Fixes

  • 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.
Back to SQL Management Suite Releases