What are some of the highlights of SQL Diagnostic Manager Pro?

by Oct 24, 2019

IDERA offers a wide range of products covering the needs of database administrators (DBA) for Microsoft SQL Server. Also, IDERA provides a wide range of capabilities within SQL Diagnostic Manager (SDM) spanning the demands of complete and holistic performance management and analysis.

SDM helps database administrators to find and fix SQL Server performance problems in physical, virtual, and cloud environments. Unlike its competition, it provides effective scalability, advanced SQL query analysis and optimization, prescriptive analysis with corrective SQL scripts, powerful automated alert responses, broad PowerShell integration, complete customization, and extensive support for current and legacy SQL Server and Windows.

For more advanced application transaction monitoring and SQL query optimization capabilities, IDERA offers SQL Diagnostic Manager Pro, which includes SDM plus the add-ons SQL Workload Analysis (SWA) and SQL Query Tuner (SQT).

SWA provides detailed wait state analysis for applications and transactions. SQT optimizes SQL queries

For example, combining the deep functionality and customizable monitoring and presentation of SDM with the quick drill-down transaction monitoring and recommendations of the add-on SWA provides the best of both worlds. That functionality includes the simplified drill-down interface when needed without sacrificing the context of complete holistic monitoring.

Read the 8-page solution brief “Highlights of SQL Diagnostic Manager Pro to learn about the critical features of IDERA’s SDM Pro. These key features include wait type analysis, user interface, ease of use, history, database server load, database server and cloud support, integrated product portfolio, user community, and customer base.

Click here to read the solution brief.