Compare the top SQL Server query tuning tools

IDERA is focused on delivering the industry’s most complete solution for SQL Server optimization. SQL Query Tuner offers extensive capabilities for SQL Server query performance optimization, including a unique visual tuning diagram feature.

Compare, side by side, the features and functionalities of some of the query tuning tools the market has to offer. Download a free trial of SQL Query Tuner today! (SQL Query Tuner is an add-on to SQL Diagnostic Manager for SQL Server).

IDERA SQL Query Tuner SQL Sentry Plan Explorer Quest SQL Optimizer SQL Server Management Studio
Capture workload profile by scanning database for SQL execution activity for time period
 
 
add-on
SQL tuning session via manual typing within SQL editor or loading a text file
 
 
 
 
SQL tuning session by scanning database for current SQL execution activity
 
 
 
Display SQL statement's database execution plan
 
 
 
 
Automatically generate SQL rewrites to potentially improve run time statistics
 
 
User can specify rules for automatic SQL rewrite allowances and exclusions
 
 
SQL rewrites can generate candidates using native database optimizer hints
 
 
SQL rewrites can generate candidates by transforming the SQL syntax itself
 
 
Recommend missing indexes which would improve execution plan
 
 
 
 
Test SQL load scalability by running multiple concurrent sessions for SQL statement
 
 
Visual tuning diagram that clarifies the data context, data relationships, data sizes and join relationships
 
 

With a rich set of features, IDERA SQL Query Tuner enables database professionals to easily improve the performance of their SQL code and tune SQL like a professional. It can capture workload profiles by scanning databases for SQL execution activity for a time period. Also, it can automatically generate SQL rewrites to improve potentially run time statistics. Users can specify rules for automatic SQL rewrite allowances and exclusions. 

SQL Query Tuner is a leading SQL tuning tool. It provides SQL rewrites that can generate candidates by transforming the SQL syntax itself. It can test SQL load scalability by running multiple concurrent sessions for SQL statements. Also, it provides a visual tuning diagram that clarifies the data context, data relationships, data sizes and join relationships.

SQL Query Tuner helps database administrators to tune and profile SQL code across database platforms. Unlike its competition, it provides automated SQL tuning and performance optimization suggestions with color-coded index analysis, database profiling of wait-time analysis for a single stored routine or an entire data source, SQL stress load testing to simulates a production environment with parallel users and executions over a specific period of time or execution cycle, and review of SQL execution and performance costs using explain plans.

Download a free, full function 14 day trial of IDERA SQL Query Tuner right now and discover for yourself how it can make your life simpler, save your company time and money, and help make you a rock star database professional in your organization.

Download This Comparison
SQL Query Tuner

  • Granular wait state monitoring
  • Continuous SQL sampling
  • Intuitive drill down to view top activity
  • Query plan tuning and recommendations
  • Lock and latch resolutions
  • Storage visibility and contention resolution
Start for Free
Share This
Contact IDERA:
+1 (713) 523-4433