Comparison: Compare the two editions of the best SQL Server monitoring tool

IDERA relentlessly delivers the industry’s most complete solution for comprehensive and continuous SQL Server performance monitoring, alerting, and diagnostics.

Compare, side by side, the features, and functionalities of the two editions of the best SQL Server monitoring tool that the market has to offer.

SQL Diagnostic Manager Pro includes SQL Diagnostic Manager, the SQL Workload Analysis add-on, and the SQL Query Tuner add-on.

SQL Diagnostic Manager Pro
SQL
Diagnostic
Manager
SQL
Workload
Analysis
SQL
Query
Tuner
physical and virtual server monitoring
 
 
 
cloud monitoring
 
   
mirroring, replication, clusters, availability group monitoring
 
   
tempdb monitoring
 
   
pinpoint locks, blocks, and deadlocks with drill down
 
 
 
custom counters
 
   
custom reports
 
   
capacity planning
 
   
historical trends performance query plans  
performance baselines
 
   
alerting with predictions and recommendations
 
   
adaptive alert thresholds
 
   
automated alert response actions
 
   
ranked expert tuning advice with executable scripts
 
   
PowerShell scripting
 
   
SCOM integration
 
   
customizable and scalable desktop console
 
 
 
customizable web console
 
 
 
mobile console
 
   
customizable dashboard with drill-down analysis performance transactions  
query monitoring basic detailed detailed
query wait time analysis basic detailed detailed
explain plans
 
 
 
query tuning and recommendations  
 
 
query plan tuning and recommendations  
 
 
lock and latch resolutions  
 
 
storage contention resolution  
 
 
continuous and high-granularity query sampling  
 
 
visual query tuning    
 
batch query tuning    
 
query rewrite    
 
explain plan cost    
 
index analysis    
 
continuous query profiling with drill down    
 
query load testing simulation    
 
automation via command line interface    
 

Discover why IDERA is the Best SQL Server Performance Monitoring Tool

SQL Diagnostic Manager, the SQL Workload Analysis add-on, and the SQL Query Tuner add-on monitor physical and virtual servers. They pinpoint locks, blocks, and deadlocks with drill down, and they display explain plans. Access SQL Diagnostic Manager and SQL Query Tuner via their customizable and scalable desktop console. Access SQL Diagnostic Manager and SQL Workload Analysis via their customizable web console. SQL Workload Analysis and SQL Query Tuner also provide detailed query monitoring and query wait time analysis.

SQL Diagnostic Manager also monitors physical and virtual servers, cloud environments, mirroring, replication, clusters, availability groups, and tempdb. It also offers custom counters and reports, capacity planning, historical performance trends, performance baselines, alerting with predictions and recommendations, and adaptive alert thresholds. It also has automated alert response actions, ranked expert tuning advice with executable scripts, PowerShell scripting, and SCOM integration. Also, access it via the mobile console. Further, benefit from the customizable performance dashboard with drill down analysis, query monitoring, query wait time analysis.

The SQL Workload Analysis add-on also offers historical query plan trends, a customizable transactions dashboard with drill down analysis, detailed query monitoring, and detailed query wait time analysis. It also provides query tuning and recommendations, query plan tuning and recommendations, lock and latch resolutions, storage contention resolution, and continuous and high-granularity query sampling.

The SQL Query Tuner add-on also provides visual query tuning, batch query tuning, query rewrite, explain plan cost, index analysis, continuous query profiling with drill down, query load testing simulation, and automation via the command line interface.

Download a free, fully functional, 14-day trial of SQL Diagnostic Manager now! For assistance with downloading and installing the SQL Workload Analysis add-on and the SQL Query Tuner add-on, please contact Sales.

Topics : Database Diagnostics,Database Monitoring,Database Performance,SQL Query Performance,

Products : SQL Diagnostic Manager for SQL Server,SQL Query Tuner,SQL Workload Analysis,