SQL diagnostic manager provides the following new features and fixed issues.

9.0 New features

Integration with the Idera Dashboard

SQLdm 9.0 now integrates with the Idera Dashboard, a common technology framework, designed to support the Idera product suite. Users are able to obtain an overview of the status of their SQL Servers and hosted databases all in a consolidated view and navigate to individual product dashboards for details. The Idera Dashboard provides a central set of services for managing users, product registry, instance registry, aggregated alerts across Idera applications, a central web server, and tags for grouping instances. For additional information, see Navigate the Idera Dashboard.

 

New advanced query views

SQLdm 9.0 takes SQL diagnostic manager’s capabilities around query monitoring and diagnostics to the next level with a new Main Query view along with two low-level views (Query Signature and Query Details views).  Users are now able to explore query data in multiple ways and easily get a handle of query performance in their environment. In SQLdm 9.0 query monitoring is enabled by default for SQL Server instances running SQL Server 2008+, and collection is performed through Extended Events which has minimum impact on your SQL Server performance.  Improved query monitoring allows for capturing of Query Execution Plans and provides graphical representations of the same in the Plan Diagram of the Query Details view.  In addition, you can view the actual XML, SQL Text, and referenced columns of a query execution plan. For additional information, see View your SQL Server queries information.

 

Improved and integrated SQLdm web console

SQLdm 9.0 provides a fully functional web console that integrates seamlessly with the Idera Dashboard (common technology framework) and is easy to access from any connected browser.  The SQLdm web console provides the overall status of a SQL Server environment to help diagnose any issues.  Users can quickly view the status of a single instance or instance groups, view all active alerts in their SQL Server environment and drill down for details, or select different sub-views to diagnose performance issues faster, and view top values for selected metrics. In addition, users are able to access the new advanced query views (see above) only from the SQLdm web console and not from the SQLdm desktop client console. For additional information, see Navigate the web console dashboard.

 

Licensing and version upgrading –

Upgrade to SQLdm 9.0

Customers upgrading from previous SQLdm versions to SQLdm 9.0 need a new license key or it is not possible to continue with the upgrade process.  Users can access the Idera Customer Portal at the moment of upgrade from the license management window in SQLdm (Help > Manage Licenses) or directly at https://idera.secure.force.com. Information necessary to generate a new license key is provided in the license management screen or the portal.

Help documentation –

SQLdm Help (User Guide and Release Notes) is now wiki-hosted and available at wiki.idera.com > SQL Diagnostic Manager. 

9.0 Fixed issues

Query Monitor

  • An issue preventing users from enabling the Query Monitor in monitored SQL Server 2000 instances no longer occurs.

Queries

  • An issue in the Queries tab and corresponding Statement mode, Signature mode and query history views, causing queries exported into Excel to truncate, no longer occurs.

Alerts

  • This release fixes an issue that prevented users from knowing when Repository grooming had timed out.  SQLdm 9.0 includes a new alert SQLdm Repository Grooming Time out that notifies users when SQLdm no longer deletes stored metrics in the Repository at the set schedule.  To configure this alert access the Alert Configuration window.

Reports

  • An issue preventing users from running the Disk Details report of the Resources analysis reports no longer occurs.

 

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
  • No labels