SQL Server - SQL Discovery and Tuning Suite

  1. SQL Discovery and Tuning Suite- includes SQL Diagnostic Manager for SQL Server v12.3

    Release Notes: Factor for SQL Diagnostic Manager Console. Added a new Search feature for handling long lists across your servers, filters, alerts, and more. Added a Step Forward or Backward with the drill-down option. ... Custom Counters SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations. SQL Diagnostic Manager successfully applies Custom Counter in new Servers ... when using templates. SQL Diagnostic Manager allows selecting and applying custom counters to all servers when creating metric alert responses for cluster environments. When using the SQL Diagnostic ...

  2. SQL Discovery and Tuning Suite- includes SQL Diagnostic Manager for SQL Server v12.2

    Release Notes: 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 ...

  3. SQL Discovery and Tuning Suite- includes SQL Diagnostic Manager for SQL Server v12.0

    Release Notes: monitors the servers and SQLDM Management service memory consumption is as expected. SQL Diagnostic Manager now correctly generates the OS Privileged CPU and User CPU Usage alerts. The Filegroup Space Full ... Thumbnail view works as expected when a server alert triggers a status change. SQL Diagnostic Manager now takes primary nodes instances to generate the Days since last backup alert, avoiding false alerts. ... The Session CPU Time(seconds) alert raises for on-premise instances. When a job exceeds the time limit, the SQL Server Agent Long Running Job (Percent) alert raises. If the job is stopped, completed, ...

  4. SQL Diagnostic Manager for SQL Server updated

    Release Notes: interfaces. Added a Heatmap Overview in Windows Console to better triage the relative health of a large number of Microsoft SQL Server environments. Improved Grid Overview with Alert Status by Category. ... for Amazon RDS for SQL Server. Added new alerts and alert template for Amazon RDS- All existing applicable alerts with on-premises SQL Server are enabled in addition to new alerts specific to RDS SQL. Alerts ... assigned. Consistency with on-premises SQL Server monitoring- Monitor Amazon RDS, Microsoft Azure SQL and on-premises SQL Server from a single-pane-of-glass and an interface organized in the same manner ...

  5. SQL Discovery and Tuning Suite Compatibility

    Compatibility: SQL Diagnostic Manager for SQL Server Supported Operating Systems Windows Server 2022 Windows Server 2019 Windows Server 2016 Windows Server 2012 R2 Windows Server 2012 Windows 11 Windows 10 ... Monitored Database Platforms Microsoft SQL Server 2022, 2019, 2017, 2016, 2014 SQL Query Tuner Supported Operating Systems Microsoft Windows 7, 8, 8.1, 10 and 11 Microsoft Windows Server 2008 SP1, 2008 R2, ... Machine (VM) Snowflake Managed Database Instances Microsoft SQL Server 2022* (Windows), 2019* (Windows), 2017* (Windows), 2016*, 2014*, 2012, 2008 and 2005 * Supports only a subset of the features ...

  6. SQL Discovery and Tuning Suite- includes SQL Defrag Manager v3.5.1

    Release Notes: Adds support for Microsoft SQL Server 2019. Bug fixes. 0 ...

  7. SQL Discovery and Tuning Suite- includes SQL Query Tuner v18.4

    Release Notes: Added support for Microsoft SQL Server 2022. Updates in SQL Query Tuner v18.4.x 1 ...

  8. SQL Discovery and Tuning Suite

    Release Notes: Discover and tune Microsoft SQL Servers. IDERA's SQL Discovery and Tuning Suite includes 3 key IDERA products; SQL Diagnostic Manager- SQL Server performance monitoring, diagnostics, ... and tuning. SQL Inventory Manager- Discover, Track and Manage Your SQL Server Inventory. SQL Defrag Manager- Find and fix SQL fragmentation hot spots fast. ...

  9. SQL Discovery and Tuning Suite- includes SQL Workload Analysis v1.7.3

    Release Notes: to be rewritten for SQL Server architecture. CPU spikes when SQLDM and SQLWA running on same machine and it goes to 100%. Remote SQL Server instances are showing question mark in SWA 1.7.2. Unable to add Server due ... to different DB Server Collation settings. Support for SQL Server 2022. SWA PMDB support on SQL Server 2022 instance. 0 ... Completely revamped the grooming (purge) process which sees a reduction in the size of the SWA repository and the size of the SQL Transaction Log. This prevents the SWA repository from growing too ...

  10. SQL Discovery and Tuning Suite- includes SQL Inventory Manager v2.6.5

    Release Notes: IDERA SQL Inventory Manager and SIM Repository now support SQL Server 2022. Now comes bundled with Dashboard 4.8.1. Databases under the DB on Availability Group by Database view are now showing ... as expected. Fixed bug related to the automatic update of the SQL Server build list. Passwords stored in SQLInventoryManagerService and SQLInventoryManagerCollectorService log files are now correctly encrypted. ...

  11. About SQL Discovery and Tuning Suite

    About SQL Discovery and Tuning Suite

    Description: Discover and tune Microsoft SQL Servers. SQL Discovery and Tuning Suite includes 3 key IDERA products; SQL Diagnostic Manager for SQL Server performance monitoring, diagnostics, and tuning, SQL ... Inventory Manager to discover, track and manage your SQL Server inventory, and SQL Defrag Manager to find and fix SQL fragmentation hot spots fast. SQL Discovery and Tuning Suite manages inventory, monitors ... performance, analyzes workload, tunes queries, and defragment indexes for SQL Server. SQL Diagnostic Manager- Pro Version SQL Server performance monitoring, diagnostics, and tuning. Monitor performance ...

  12. SQL Discovery and Tuning Suite- includes SQL Defrag Manager v3.8

    Release Notes: Added support for Microsoft SQL Server 2022. Configuration Installer does not check for.NET Framework 4.8. Customers experience additional slowness in console navigation after Upgrade. General ...

  13. SQL Discovery and Tuning Suite- includes SQL Defrag Manager v3.5.0

    Release Notes: Added support for SQL Server 2017. Added compatibility with TLS 1.2 to support updated security and PCI requirements. Added ability to view a table’s schema. Added a new option to rediscover server ... in SQL Defrag Manager v3.x 1 ...

  14. SQL Discovery and Tuning Suite- includes SQL Inventory Manager v2.6.2

    Release Notes: Account Control window displays IDERA as the SQL Inventory Manager publisher. SIM 2.6.2 registers successfully SQL Server instances, and cloud instances with SQL credentials only. SIM 2.6.2 gets registered ... in plain text anymore. SIM 2.6.2 discovers SQL Instances hosted in other domains properly. The SQL Server is Down alert is properly described in Manage Health Checks. In the Explorer view, the data now ... 2012 with SQL Server 2014 Standard. Databases on the secondary node of an Availability Group do not raise Databases Without a Backup health checks anymore. Dropped databases do not show up ...

  15. SQL Discovery and Tuning Suite- includes SQL Inventory Manager v2.6

    Release Notes: aliases for each instance wherever instance is displayed. Microsoft SQL Server 2019 support. Bug fixes and enhancements. Updates in SQL Inventory Manager v2.6.x 1 ...

  16. SQL Discovery and Tuning Suite- includes SQL Inventory Manager v2.6.1

    Release Notes: the appropriate core factor for each SQL Server version under SQL Licensing by Instances view. Users can add a New Virtualization Host Servers in the Manage VM Configuration window. E-mail shows alert with Alert ... from a different domain, now authenticates properly on the server hosting SIM. The console does not display dropped databases, and they are not shown Online. SQL Inventory Manager 2.6.1 performs Health ... SIM Charge Back Reports now runs properly. When  the user is modified, SQL Inventory Manager 2.6.1 restarts collector Service after completing the save operation. SQL Inventory Manager 2.6.1 ...

  17. SQL Discovery and Tuning Suite- includes SQL Workload Analysis v1.7.4

    Release Notes: SQL Workload Analysis has been successfully upgraded from SWA 1.7.1, 1.7.2, and 1.7.3 to 1.7.4. Removed Postgres and Libcurl references. Upgraded ActiveMQ from 5.16.3 to 5.16.6. Upgraded SFL4J log4j ...

  18. SQL Discovery and Tuning Suite- includes SQL Inventory Manager v2.6.3

    Release Notes: The IDERA Dashboard no longer generates AD warnings for authentication failures, therefore, the CWF Service account does not lock anymore. When a server alias is registered with a name matching ... another actual physical server’s name, both servers are now properly registered and functional. The Server details screen displays the data properly for Clustered instances. Alert messages are generated ...

  19. SQL Discovery and Tuning Suite- includes SQL Workload Analysis v1.7.2

    Release Notes: the special character instance. Able to monitor 2 servers while SWA is licensed for 1 server only. SQLWA Repository DB credentials- including password, logged as plain text in the logs. SQLWA 1.7.2 should ... be packaged with CWF 4.7. Run as administrator on exe file for the 1.7.1#16 the build number is showing 1.7.0. Log4j security vulnerability found in the Workload Analysis component. Updates in SQL Workload ...

  20. SQL Discovery and Tuning Suite- includes SQL Inventory Manager v2.6.4

    Release Notes: Search box The Search box can now search by Tag. 0 ...