Optimize SQL Server Queries

Organizational Impact

• Improve database end-user experience.
• Improve database workload and database performance against organization-oriented service-level agreements.
• Reduce lost staff productivity due to database-related performance problems.
• Decrease database-related IT costs.

Team Impact

• Shorten mean time to resolution of database issues.
• Proactively resolve problems before they impact the organization.
• Improve collaboration between database administrators and database developers.
• Increase efficiency of database administrators and database developers.
• Reduce finger-pointing from other IT groups and third-party vendors.
• Maximize infrastructure investments by tuning database performance.

Benefits

• Identify problematic SQL queries via database profiling of wait time analysis.
• View automatically generated tuning recommendations with the SQL query tuning wizard.
• Understand the impact of SQL statements on the database using visual SQL tuning diagrams.
• Verify SQL queries performance with load testing in simulated production environments.
• Reduce training requirements and streamline collaboration for tuning SQL queries with the intuitive interface.

Pinpoint Problematic SQL Queries with Wait Time Analysis

Quickly and easily identify SQL queries that cause poor database performance via database profiling that displays a graphical visualization of wait time analysis. Monitor an entire data source within a configurable span of time with continuous profiling. Gain a better understanding of how SQL Server plans to execute SQL queries and the performance costs with explain plans. Share information captured during the profiling process with reporting.

Receive Automated Tuning Suggestions

View automatically generated suggested solutions with the SQL query tuning wizard to provide an essential context for tuning SQL queries. View color-coded index analysis for used, not used, and missing indexes with recommendations for optimum performance. Generate possible cases and find the best alternative to a given SQL statement by including SQL query rewrites and hint injections.

Visually Tune Complex SQL Queries

Turn text-based SQL queries into unique visual SQL query tuning diagrams. Understand the impact of SQL statements on the database using the diagrams instead of more complicated execution plans. Display indexes and constraints on tables and views with table statistics, and the joins used in a SQL statement (such as Cartesian joins, implied Cartesian joins, and many-to-many relationships) with the diagrams.

Load Test in Simulated Production Environments

Verify the performance of existing and alternative SQL queries against the database via load testing. Configure SQL queries to run multiple times in parallel and to observe how they respond to simulated production environments without the risk of actually testing in production.

Streamline SQL Query Tuning for SQL Server

Tune poorly performing SQL queries for SQL Server from an intuitive interface. Reduce training requirements and streamline collaboration among teams across the organization.

Continuous Wait State and Transaction Monitoring

Monitor wait states and capture transactions of applications. Get a real-time view of the entire instance and database with continuous sampling and high granularity as fast as 1 second.

Quick Drill-down for Actionable Advice

Easily drill down to isolate problems quickly. View details of the captured transactions – such as top CPU activity, waits, databases, and statements versus top logins, machines, and applications – to pinpoint problems. Display and tune execution plans with actionable expert recommendations, illuminate demanding transactions, and resolve locks and latches.

Historical Query Plan Trends

SQL Workload Analysis for SQL Server delivers valuable real-time and historical data to help tune queries. Investigate historical query plan trends in SQL Server 2005 and newer systems.

Integration with SQL Diagnostic Manager for SQL Server

SQL Workload Analysis for SQL Server integrates with SQL Diagnostic Manager for SQL Server to provide wait state and transaction monitoring. From the dashboard of SQL Diagnostic Manager for SQL Server, launch SQL Workload Analysis for SQL Server in context to isolate further the transaction causes of alerts of SQL Diagnostic Manager for SQL Server for a quick resolution.

Simple Web-based Dashboard

SQL Workload Analysis for SQL Server provides a single web-based interface that is accessible via a browser from any machine that can connect to the framework machine. The customizable dashboard displays a quick and comprehensive overview of statistical analysis and activity trends of top database activity. Quickly drill down into the details of the captured transactions to isolate slow SQL statements, illuminate demanding operators, receive automatic expert recommendations to improve SQL queries, and analyze and tune execution plans.

Agentless and Low Impact

SQL Workload Analysis for SQL Server monitors SQL Server instances remotely from a dedicated framework machine. SQL Workload Analysis for SQL Server is agentless and does not install additional services, databases, tables, extended stored procedures or anything else on the production systems. This simple architecture significantly reduces server footprint, simplifies the installation and upgrade process, and eliminates risk agents on the performance of the monitored SQL servers.

SQL Query Tuner for SQL Server Product Video

Watch this video to learn about how SQL Query Tuner can help you to boost the performance monitoring power of SQL Diagnostic Manager with SQL query tuning for SQL Server.

Compare the Best SQL Server Query Tuning Tools

IDERA relentlessly delivers the industry’s most complete solution for profiling and tuning SQL queries for SQL Server and tirelessly supports the SQL Server community with 100% free tools and expert advice.

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

	IDERA SQL Query Tuner	SQL Sentry® Plan Explorer	Quest® SQL Optimizer	SQL® Server Management Studio
Capture Workload Profile by scanning database for SQL query execution activity for the period.				Add-on
SQL Tuning Session via manual typing within SQL query editor or loading a text file.
SQL Tuning Session by scanning database for current SQL query execution activity.
Display SQL statement's database execution plan.
Automatically generate SQL query rewrites to improve runtime statistics potentially.
he user can specify rules for automatic SQL query rewrite allowances and exclusions.
SQL query rewrites can generate candidates using native database optimizer hints.
SQL query 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 DBAs and developers to quickly improve the performance of their SQL queries for SQL Server like a professional.

SQL Query Execution Performance: Identify and diagnose performance bottlenecks and problematic SQL queries for SQL Server without agents or placing a significant load on the target database. The profile chart shows the CPU, input and output, and other wait activity over the course of the session, in real-time while profiling is in progress. Drill down into the execution details for any given statement, including the SQL query text, events, sessions, child cursors, blockers, procedures, and SQL query details.