To maintain end-user satisfaction, it is critical to optimize the performance of the SQL queries that applications use to communicate with the underlying databases. SQL Query Tuner optimizes SQL queries by quickly discovering, diagnosing, and optimizing poor-performing SQL queries.
Survey of users of SQL Query Tuner, 2019
Automate SQL query tuning from the intuitive graphical user interface. Streamline and automate frequent and repetitive tasks with powerful wizards.
Create and run tuning jobs for a single statement or a batch of statements. Tune all data manipulation language statements, stored routines, and entire SQL files.
Generate cases in the SQL tuner or type SQL queries into the integrated development environment to view suggested SQL rewrites.
Generate all possible cases and find the best alternative to a given SQL statement with SQL query rewrites and hint injection.
Customize the subset of hints for consideration for hint injection and alternative execution paths.
Display the explain plan cost for each original statement and each generated case to examine the expected cost given the execution path utilized by SQL Server.
Turn text-based SQL queries into graphical tuning diagrams that display the tables and views used in the queries, and the relationships defined in those queries.
Display indexes and constraints on tables and views, and the joins used in a SQL statement with table statistics with the visual tuning diagrams.
View used, not used, and missing indexes and view indexing recommendations for optimum performance with the color-coded index analysis.
Discover the fastest running SQL statement by running SQL queries with alternative execution paths, and apply the change with a single button click.
Spot the textual differences between any two SQL statements with the visual difference viewer.
Identify and diagnose performance bottlenecks and problematic SQL queries without agents and without placing a significant load on the target database.
Simulate parallel users and parallel executions over a specific period or execution cycle with stress testing of SQL queries.
Continuously profile an entire data source within a configurable span of time.
Show data in real-time while profiling is in progress.
Save all data and metadata about a profile session as a single entity into an archive file. Share profiles across multiple workspaces and machines to collaborate with others.
Show the CPU, input and output, and other wait activity over the course of the session in the profile chart, and zoom in and out as desired.
Display detailed information on the profiled SQL query and wait categories. Break down this information into SQL statements, events, and sessions.
Drill down into the execution details for any given statement which includes the query text, events, sessions, child cursors, blockers, procedures, and query details.
Roll up SQL statements for an accurate analysis of the number of executions in real-time.
Display explain plans in a separate view as a tree with columns and collapsible column groups.
Highlight a time interval in the profile chart to instantly change the data displayed to make it easier to see the details.
Stream profiling data into a central repository for the open session.
Save an entire profiling session to file for future analysis and reference, and to share with others.
Automate and launch profiling and tuning sessions remotely with the intuitive command-line interface.
Utilize Unicode characters throughout the application.
Unify your control by running SQL Query Tuner on cloud virtual machines with Windows — such as Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2).
Monitor your SQL Server instances running on cloud virtual machines — such as Azure VM and Amazon EC2.
Save time by using the same query tuning tool for SQL Server databases on-premises (on your physical and virtual machines); and in the private, public, and government cloud (on virtual machines).
Get the most out of the cloud with cloud storage that is mapped as network drives or removable drives on Windows. For example, map storage to Amazon Simple Storage Service (S3) and Azure Blob Storage.
Everything you need to know, all in one downloadable PDF
Learn how to visually tune complex queries with SQL Query Tuner
Compare the features of SQL Diagnostic Manager, SQL Workload Analysis, and SQL Query Tuner
Learn about using visual SQL tuning diagrams to improve database performance
Joseph D'Antoni presents the basics of how to tune queries in a SQL Server environment
Joe Celck presents syntax and query principles to produce good SQL and a maintainable schema