Database Query Tuning
for SQL Server

SQL Query Tuner

Troubleshoot and optimize database SQL queries

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.

SQL Query Tuner
  • Visually tune complex SQL queries.
  • Profile databases with wait-time analysis.
  • Load test in simulated production environments
open-quote

SQL Query Tuner reduced by more than 80% our time to analyze query wait times.

David Gomez Gutierrez, Application Database Administrator,
Grupo Financiero Banorte, S.A. de C.V.

small business, banking, Mexico

SQL Query Tuner provides us with very good SQL code analysis to improve database performance.

Database Administrator, Ministerio de Trabajo y Seguridad Social

state and local government, Costa Rica
close-quote_dark
100%

of surveyed organizations, the most important impact of SQL Query tuner is accelerated query tuning and optimization.

Survey of users of SQL Query Tuner

  • Navigate intuitive interface

    Automate SQL query tuning from the intuitive graphical user interface. Streamline and automate frequent and repetitive tasks with powerful wizards.

  • Tune in batches

    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.

  • Rewrite SQL queries

    Generate cases in the SQL tuner or type SQL queries into the integrated development environment to view suggested SQL rewrites.

  • Generate cases

    Generate all possible cases and find the best alternative to a given SQL statement with SQL query rewrites and hint injection.

  • Manage hint injection

    Customize the subset of hints for consideration for hint injection and alternative execution paths.

  • View explain plan cost

    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.

  • Visually tune SQL queries

    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.

  • View indexes and joints

    Display indexes and constraints on tables and views, and the joins used in a SQL statement with table statistics with the visual tuning diagrams.

  • Analyze indexes

    View used, not used, and missing indexes and view indexing recommendations for optimum performance with the color-coded index analysis.

  • Examine execution statistics

    Discover the fastest running SQL statement by running SQL queries with alternative execution paths, and apply the change with a single button click.

  • Compare cases

    Spot the textual differences between any two SQL statements with the visual difference viewer.

  • Sample with low-impact

    Identify and diagnose performance bottlenecks and problematic SQL queries without agents and without placing a significant load on the target database.

  • Test under load

    Simulate parallel users and parallel executions over a specific period or execution cycle with stress testing of SQL queries.

  • Profile continuously

    Continuously profile an entire data source within a configurable span of time.

  • Show live data

    Show data in real-time while profiling is in progress.

  • Share profile sessions

    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.

  • View profile chart

    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.

  • Examine execution statistics

    Display detailed information on the profiled SQL query and wait categories. Break down this information into SQL statements, events, and sessions.

  • Drill down into profiling details

    Drill down into the execution details for any given statement which includes the query text, events, sessions, child cursors, blockers, procedures, and query details.

  • Summarize execution analysis

    Roll up SQL statements for an accurate analysis of the number of executions in real-time.

  • Generate explain plans

    Display explain plans in a separate view as a tree with columns and collapsible column groups.

  • Crop time displays

    Highlight a time interval in the profile chart to instantly change the data displayed to make it easier to see the details.

  • Store profiling data

    Stream profiling data into a central repository for the open session.

  • Save profiling sessions

    Save an entire profiling session to file for future analysis and reference, and to share with others.

  • Automate and remote-control tuning sessions

    Automate and launch profiling and tuning sessions remotely with the intuitive command-line interface.

  • Use unicode characters

    Utilize Unicode characters throughout the application.

  • Install on cloud virtual machines

    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).

  • Manage SQL Server on cloud virtual machines

    Monitor your SQL Server instances running on cloud virtual machines — such as Azure VM and Amazon EC2.

  • Manage SQL Server on cloud virtual machines

    Monitor your SQL Server instances running on cloud virtual machines — such as Azure VM and Amazon EC2.

  • Monitor hybrid environments with a single tool

    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).

  • Access mapped cloud drives

    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.

Let’s get started.

Start your 14-day trial, no credit card required (but all fields are).

Commercial licenses are not supported with this trial download. To update to the latest version, please access IDERA’s customer support portal.

SQL Query Tuner is an add-on for SQL Diagnostic Manager for SQL Server.

If you would like to speak with a representative, then please call +1 (713) 523-4433.

Ready to see how SQL Query Tuner can help you monitor and manage SQL Server security on-premises and in the cloud?

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

Datasheet

SQL Query Tuner
Datasheet

Everything you need to know, all in one downloadable PDF.

Whitepaper: The Guide to Learning PowerShell

Visually Tune
Complex Queries

Learn how to visually tune
complex queries with
SQL Query Tuner

compare sql

Compare Editions of
SQL Diagnostic Manager

Compare the features of SQL
Diagnostic Manager, SQL Workload
Analysis, and SQL Query Tuner

infographic

Why Should You Use Visual
SQL Tuning Diagrams

Learn about using visual SQL
tuning diagrams to improve
database performance

Webcast

SQL Server
Query Tuning

Compare the features of SQL
Diagnostic Manager, SQL Workload
Analysis, and SQL Query Tuner

White Paper

SQL Syntax and
Query Performance

Joe Celck presents syntax and query
principles to produce good SQL
and a maintainable schema

You can view the list of all resources for SQL Query Tuner in the Resource Center.