Database Query Tuning for SQL Server

SQL Query Tuner

SQL Query Tuner for SQL Server Product Tour

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.

Generate SQL Statements and Cases: Create and run tuning jobs for a single statement or batch of statements. Tune all data manipulation language statements, stored routines, and entire SQL files. View execution statistics for SQL statements and cases. View suggested SQL query rewrites when generating cases in the SQL query tuner and when typing SQL code in the SQL integrated development environment.

Tune SQL Queries like a Professional: The SQL query tuning wizard automatically suggests solutions for tuning SQL queries for SQL Server. The color-coded Index Analysis shows used, not used, or missing indexes and offers recommendations for optimum performance. Find the best alternative to a given SQL statement by including SQL query rewrites and hint injections.

Visually Tune Complex SQL Queries: Unique in the industry, Visual SQL Tuning diagrams turn text-based SQL queries into graphical SQL query diagrams to show the impact of SQL statements on the SQL Server database. The Visual SQL Tuning diagram displays indexes and constraints on tables and views with table statistics, and the joins used in a SQL statement.

Simulate Production Environments: Load testing verifies the performance of existing and alternative SQL queries against the SQL Server database. Configure queries to run multiple times in parallel and see how they respond to simulated production environments without the risk of actually testing in production.

Start for FREE No credit card required! Fully functional for 14 days

(SQL Query Tuner is an add-on to SQL Diagnostic Manager.)