Compare the Best SQL Server Performance Monitoring Tools

Reduced availability and performance of SQL Server can severely affect the critical applications that it supports.

Illustration

Ensuring performance and availability is the most critical function for database administrators today.

They also need to support growing deployments of databases with limited resources. Access to reliable, real-time information on the status and health of the complete environment is essential, along with diagnostic tools to pinpoint and resolve performance issues quickly.

Compare, side by side, the features and functionalitiesof the best SQL Server monitoring tools that the market has to offer.

  IDERA
SQL Diagnostic Manager
SQL Sentry®
Performance Advisor
Redgate®
SQL Monitor
Quest®Spotlight
on SQL Server
Query Wait Monitoring Checkmark Checkmark Checkmark Checkmark
Always On Availability
Group Monitoring
Checkmark Checkmark Checkmark Checkmark
Mirroring, Replication
& Cluster Monitoring
Checkmark Limited* Checkmark Checkmark
Monitoring Repositories
Viewable in Single Dashboard
Checkmark 1 1 1
TempDB Monitoring Checkmark Checkmark Checkmark Checkmark
Monitored Virtual Servers VMWare & Hyper-V VMWare & Hyper-V Checkmark VMWare & Hyper-V
Integrated Messaging
& Collaboration
Checkmark Checkmark Checkmark Checkmark
Predictive SQL Alerts Checkmark Checkmark Checkmark Checkmark
Custom SQL
Permission Control
Checkmark Checkmark Checkmark Checkmark
Integrated Expert
Recommendations
Checkmark Checkmark Checkmark Checkmark
Mobile Access Checkmark View Only Checkmark Checkmark
Microsoft® SCOM Integration Checkmark Checkmark Checkmark Checkmark
PowerShell Scripting Checkmark Checkmark Checkmark Checkmark
SQL Server Express Support Checkmark Checkmark Checkmark Checkmark
SQL Server Software Solutions 18 4 15 4
Integrated SQL Server
Solutions Dashboard
Checkmark Checkmark Checkmark Checkmark
Query Wait Monitoring Checkmark
Always On Availability
Group Monitoring
Checkmark
Mirroring, Replication
& Cluster Monitoring
Checkmark
Monitoring Repositories
Viewable in Single Dashboard
Checkmark
TempDB Monitoring Checkmark
Always On Availability
Group Monitoring
VMWare & Hyper-V
Integrated Messaging
& Collaboration
Checkmark
Predictive SQL Alerts Checkmark
Custom SQL
Permission Control
Checkmark
Integrated Expert
Recommendations
Checkmark
Mobile Access Checkmark
Microsoft® SCOM
Integration
Checkmark
PowerShell Scripting Checkmark
SQL Server Express
Support
Checkmark
SQL Server Software
Solutions
18
Integrated SQL Server
Solutions Dashboard
Checkmark
Query Wait Monitoring Checkmark
Always On Availability
Group Monitoring
Checkmark
Mirroring, Replication
& Cluster Monitoring
Limited*
Monitoring Repositories
Viewable in Single Dashboard
1
TempDB Monitoring Checkmark
Always On Availability
Group Monitoring
VMWare & Hyper-V
Integrated Messaging
& Collaboration
Checkmark
Predictive SQL Alerts Checkmark
Custom SQL
Permission Control
Checkmark
Integrated Expert
Recommendations
Checkmark
Mobile Access View Only
Microsoft® SCOM
Integration
Checkmark
PowerShell Scripting Checkmark
SQL Server Express
Support
Checkmark
SQL Server Software
Solutions
4
Integrated SQL Server
Solutions Dashboard
Checkmark
Query Wait Monitoring Checkmark
Always On Availability
Group Monitoring
Checkmark
Mirroring, Replication
& Cluster Monitoring
Checkmark
Monitoring Repositories
Viewable in Single Dashboard
1
TempDB Monitoring Checkmark
Always On Availability
Group Monitoring
Checkmark
Integrated Messaging
& Collaboration
Checkmark
Predictive SQL Alerts Checkmark
Custom SQL
Permission Control
Checkmark
Integrated Expert
Recommendations
Checkmark
Mobile Access Checkmark
Microsoft® SCOM
Integration
Checkmark
PowerShell Scripting Checkmark
SQL Server Express
Support
Checkmark
SQL Server Software
Solutions
15
Integrated SQL Server
Solutions Dashboard
Checkmark
Query Wait Monitoring Checkmark
Always On Availability
Group Monitoring
Checkmark
Mirroring, Replication
& Cluster Monitoring
Checkmark
Monitoring Repositories
Viewable in Single Dashboard
1
TempDB Monitoring Checkmark
Always On Availability
Group Monitoring
VMWare & Hyper-V
Integrated Messaging
& Collaboration
Checkmark
Predictive SQL Alerts Checkmark
Custom SQL
Permission Control
Checkmark
Integrated Expert
Recommendations
Checkmark
Mobile Access Checkmark
Microsoft® SCOM
Integration
Checkmark
PowerShell Scripting Checkmark
SQL Server Express
Support
Checkmark
SQL Server Software
Solutions
4
Integrated SQL Server
Solutions Dashboard
Checkmark

*SQL Sentry® Performance Advisor offers only cluster monitoring.

IDERA compiled this feature comparison based on available product information.
We recommend that you perform proper due diligence to make sure you choose the
best performance monitoring tool for your SQL Server environment.
Please contact Sales if you have any concerns or feedback.

Diagnostics

Download a free, fully functional, 14-day trial of SQL Diagnostic Manager now!

Start Free Trial

Or contact Sales for more information.

Discover why IDERA SQL Diagnostic Manager is the Best Performance Monitoring Tool for SQL Server

There are many essential capabilities that database administrators require that you can only get with IDERA SQL Diagnostic Manager. Most solutions provide basic monitoring capabilities. However, with SQL Diagnostic Manager, you get much more. SQL Diagnostic Manager has support for mirroring, replication and cluster monitoring, tempdb monitoring, and virtual server monitoring for VMware and Hyper-V built-in and at no additional charge.

SQL Diagnostic Manager is the only solution that uses predictive alerts. These alerts analyze recent trends to provide early insight into potential problems before they even happen. SQL Diagnostic Manager is also the only solution that includes a Microsoft System Center Operations Manager (SCOM) plug-in and a PowerShell scripting snap-in. And we cannot forget to mention IDERA"s 18 other SQL Server tools and nine free SQL Server tools, making it the best value on the market today.

Download a free, fully functional, 14-day trial of SQL Diagnostic Manager now!

Start Free Trial

Or contact Sales for more information.

Performance

Proactively Monitor SQL Server Performance with IDERA SQL Diagnostic Manager

Grow your business by maximizing the availability and performance of your SQL Server databases with robust diagnostics, intelligent alerts, and expert recommendations.

Your business depends on the reliability and speed of your SQL Server databases to support critical applications. IDERA tools provide DBAs with reliable real-time information on the status and health of the entire SQL Server environment. IDERA also provides tools to predict, pinpoint, and resolve performance issues rapidly.

Performance

Reduce costly server downtime, react quickly to performance problems, and increase and ensure availability.

Laptop
Funnel

Find query bottlenecks:

Keep data delivery fast and consistent by spotting the queries that are slowing your system down, with query capture, sophisticated filtering, and user-friendly visualizations.

Alert

Alert predictively:

Avoid scrambling to fix database problems with customizable and predictive alerts to spot approaching issues. Keep administrators and users in the know about system health, with automatic email notifications, Windows taskbar notifications, Windows Event Log notices, and SQL and PowerShell script execution.

Expert Advice

View expert advice:

Solve everyday problems fast and improve database performance with expert recommendations. Apply fixes enterprise-wide with a unified, intuitive interface - from configuration to query construction, security to memory use.

Alerts List

View top issues and alerts:

Save time by giving administrators a single-pane-of-glass interface for monitoring and alerts. Your databases are all displayed, and all in one place, for fast action when something goes wrong.

Funnel

Find query
bottlenecks:

Keep data delivery fast and consistent by spotting the queries that are slowing your system down, with query capture, sophisticated filtering, and user-friendly visualizations.

Alert

Alert
predictively:

Avoid scrambling to fix database problems with customizable and predictive alerts to spot approaching issues. Keep administrators and users in the know about system health, with automatic email notifications, Windows taskbar notifications, Windows Event Log notices, and SQL and PowerShell script execution.

Expert Advice

View expert
advice:

Solve everyday problems fast and improve database performance with expert recommendations. Apply fixes enterprise-wide with a unified, intuitive interface - from configuration to query construction, security to memory use.

Alerts List

View top issues
and alerts:

Save time by giving administrators a single-pane-of-glass interface for monitoring and alerts. Your databases are all displayed, and all in one place, for fast action when something goes wrong.

Download a free, fully functional, 14-day trial of SQL Diagnostic Manager now!

Start Free Trial

Or contact Sales for more information.

Best Performance

Compare the Two Editions of the Best Performance Monitoring Tool for SQL Server.

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

The included SQL Workload Analysis add-on provides a granular breakdown of wait states with easy drill-down to isolate problems quickly. It delivers valuable real-time and historical data and actionable advice to improve performance.

The included SQL Query Tuner add-on maximizes database and application performance by quickly finding and fixing poor-performing queries. It eliminates bottlenecks by graphically profiling critical metrics inside the database.

SQL Diagnostic Manager Pro

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
SQL Workload
Analysis
SQL Query
Tuner
Physical and Virtual
Server Monitoring
Checkmark Checkmark Checkmark
Cloud Monitoring Checkmark Checkmark Checkmark
Mirroring, Replication, Clusters,
Availability Group Monitoring
Checkmark Checkmark Checkmark
TempDB Monitoring Checkmark Checkmark Checkmark
Pinpoint Locks, Blocks,
and Deadlocks with Drill-down
Checkmark Checkmark Checkmark
Custom Counters Checkmark Checkmark Checkmark
Custom Reports Checkmark Checkmark Checkmark
Capacity Planning Checkmark Checkmark Checkmark
Historical Trends Performance Query Plans Checkmark
Performance Baselines Checkmark Checkmark Checkmark
Alerting with Predictions
and Recommendations
Checkmark Checkmark Checkmark
Adaptive Alert Thresholds Checkmark Checkmark Checkmark
Automated Alert
Response Actions
Checkmark Checkmark Checkmark
Ranked Expert Tuning Advice
with Executable Scripts
Checkmark Checkmark Checkmark
PowerShell Scripting Checkmark Checkmark Checkmark
SCOM Integration Checkmark Checkmark Checkmark
Customizable and Scalable
Desktop Console
Checkmark Checkmark Checkmark
Customizable Web Console Checkmark Checkmark Checkmark
Mobile Console Checkmark Checkmark Checkmark
Customizable Dashboard
with Drill-down Analysis
Performance Transactions Checkmark
Query Monitoring Basic Detailed Detailed
Query Wait Time Analysis Basic Detailed Detailed
Explain Plans Checkmark Checkmark Checkmark
Query Tuning and
Recommendations
Checkmark Checkmark Checkmark
Query Plan Tuning and
Recommendations
Checkmark Checkmark Checkmark
Lock and Latch
Resolutions
Checkmark Checkmark Checkmark
Storage Contention
Resolution
Checkmark Checkmark Checkmark
Continuous and High-granularity
Query Sampling
Checkmark Checkmark Checkmark
Visual Query Tuning Checkmark Checkmark Checkmark
Batch Query Tuning Checkmark Checkmark Checkmark
Query Rewrite Checkmark Checkmark Checkmark
Explain Plan Cost Checkmark Checkmark Checkmark
Index Analysis Checkmark Checkmark Checkmark
Continuous Query Profiling
with Drill-down
Checkmark Checkmark Checkmark
Query Load Testing Simulation Checkmark Checkmark Checkmark
Automation Via Command-line
Interface
Checkmark Checkmark Checkmark
  • SQL Diagnostic Manager
  • SQL Workload Analysis
  • SQL Query Tuner
Physical and Virtual
Server Monitoring
Checkmark
Cloud Monitoring Checkmark
Mirroring, Replication, Clusters,
Availability Group Monitoring
Checkmark
TempDB Monitoring Checkmark
Pinpoint Locks, Blocks,
and Deadlocks with Drill-down
Checkmark
Custom Counters Checkmark
Custom Reports Checkmark
Capacity Planning Checkmark
Historical Trends Performance
Performance Baselines Checkmark
Alerting with Predictions
and Recommendations
Checkmark
Adaptive Alert Thresholds Checkmark
Automated Alert
Response Actions
Checkmark
Ranked Expert Tuning Advice
with Executable Scripts
Checkmark
PowerShell Scripting Checkmark
SCOM Integration Checkmark
Customizable and Scalable
Desktop Console
Checkmark
Customizable Web Console Checkmark
Mobile Console Checkmark
Customizable Dashboard
with Drill-down Analysis
Performance
Query Monitoring Basic
Query Wait Time Analysis Basic
Explain Plans Checkmark
Query Tuning and
Recommendations
Checkmark
Query Plan Tuning and
Recommendations
Checkmark
Lock and Latch
Resolutions
Checkmark
Storage Contention
Resolution
Checkmark
Continuous and High-granularity
Query Sampling
Checkmark
Visual Query Tuning Checkmark
Batch Query Tuning Checkmark
Query Rewrite Checkmark
Explain Plan Cost Checkmark
Index Analysis Checkmark
Continuous Query Profiling
with Drill-down
Checkmark
Query Load Testing Simulation Checkmark
Automation Via Command-line
Interface
Checkmark
Physical and Virtual
Server Monitoring
Checkmark
Cloud Monitoring Checkmark
Mirroring, Replication, Clusters,
Availability Group Monitoring
Checkmark
TempDB Monitoring Checkmark
Pinpoint Locks, Blocks,
and Deadlocks with Drill-down
Checkmark
Custom Counters Checkmark
Custom Reports Checkmark
Capacity Planning Checkmark
Historical Trends Query Plans
Performance Baselines Checkmark
Alerting with Predictions
and Recommendations
Checkmark
Adaptive Alert Thresholds Checkmark
Automated Alert
Response Actions
Checkmark
Ranked Expert Tuning Advice
with Executable Scripts
Checkmark
PowerShell Scripting Checkmark
SCOM Integration Checkmark
Customizable and Scalable
Desktop Console
Checkmark
Customizable Web Console Checkmark
Mobile Console Checkmark
Customizable Dashboard
with Drill-down Analysis
Transactions
Query Monitoring Detailed
Query Wait Time Analysis Detailed
Explain Plans Checkmark
Query Tuning and
Recommendations
Checkmark
Query Plan Tuning and
Recommendations
Checkmark
Lock and Latch
Resolutions
Checkmark
Storage Contention
Resolution
Checkmark
Continuous and High-granularity
Query Sampling
Checkmark
Visual Query Tuning Checkmark
Batch Query Tuning Checkmark
Query Rewrite Checkmark
Explain Plan Cost Checkmark
Index Analysis Checkmark
Continuous Query Profiling
with Drill-down
Checkmark
Query Load Testing Simulation Checkmark
Automation Via Command-line
Interface
Checkmark
Physical and Virtual
Server Monitoring
Checkmark
Cloud Monitoring Checkmark
Mirroring, Replication, Clusters,
Availability Group Monitoring
Checkmark
TempDB Monitoring Checkmark
Pinpoint Locks, Blocks,
and Deadlocks with Drill-down
Checkmark
Custom Counters Checkmark
Custom Reports Checkmark
Capacity Planning Checkmark
Historical Trends Checkmark
Performance Baselines Checkmark
Alerting with Predictions
and Recommendations
Checkmark
Adaptive Alert Thresholds Checkmark
Automated Alert
Response Actions
Checkmark
Ranked Expert Tuning Advice
with Executable Scripts
Checkmark
PowerShell Scripting Checkmark
SCOM Integration Checkmark
Customizable and Scalable
Desktop Console
Checkmark
Customizable Web Console Checkmark
Mobile Console Checkmark
Customizable Dashboard
with Drill-down Analysis
Checkmark
Query Monitoring Detailed
Query Wait Time Analysis Detailed
Explain Plans Checkmark
Query Tuning and
Recommendations
Checkmark
Query Plan Tuning and
Recommendations
Checkmark
Lock and Latch
Resolutions
Checkmark
Storage Contention
Resolution
Checkmark
Continuous and High-granularity
Query Sampling
Checkmark
Visual Query Tuning Checkmark
Batch Query Tuning Checkmark
Query Rewrite Checkmark
Explain Plan Cost Checkmark
Index Analysis Checkmark
Continuous Query Profiling
with Drill-down
Checkmark
Query Load Testing Simulation Checkmark
Automation Via Command-line
Interface
Checkmark
Toolset

Discover Why SQL Diagnostic Manager Pro is the Best Performance Monitoring Toolset for SQL Server

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 offers historical query plan trends, a customizable transaction 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 provides visual query tuning, batch query tuning, query rewrite, explain plan cost, index analysis, and continuous query profiling with drill-down. It also provides query load testing simulation, and automation via the command-line interface.

Download a free, fully functional, 14-day trial of SQL Diagnostic Manager now!

Start Free Trial

Or contact Sales for more information.

SQL Diagnostic Manager provides us with overall better control over our database instances, very useful baselines, and better performance and bottleneck control.

Stefan Haglund,
IT Specialist, ltkalmar.se
(state and local government, Sweden, 100 to 499 SQL Server databases)

SQL Diagnostic Manager provides us with overall better control over our database instances, very useful baselines, and better performance and bottleneck control.

Stefan Haglund,
IT Specialist, ltkalmar.se
(state and local government, Sweden, 100 to 499 SQL Server databases)

SQL Diagnostic Manager provides us with overall better control over our database instances, very useful baselines, and better performance and bottleneck control.

Stefan Haglund,
IT Specialist, ltkalmar.se
(state and local government, Sweden, 100 to 499 SQL Server databases)

Learn More About The Best Performance Monitoring Tool for SQL Server

Download a free, fully functional, 14-day trial of SQL Diagnostic Manager now!

Start Free Trial

Or contact Sales for more information.