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
  • Load test in simulated production environments
  • Streamline SQL query tuning for SQL Server

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, 500 to 999 SQL Server databases TVID 93A-5D8-CF7

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

Database Administrator, Ministerio de Trabajo y Seguridad Social

State & Local Government, Costa Rica TVID 93A-5D8-CF7
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, 2019

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

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

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

Request Demo Request Quote

(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

Play

Visually Tune
Complex Queries

Learn how to visually tune complex queries with SQL Query Tuner

Solution

Comparison of SQL
Diagnostic Manager Editions

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

Play

Why Should You Use Visual
SQL Tuning Diagrams

Learn about using visual SQL tuning diagrams to improve database performance

Webcast

SQL Server
Query Tuning

Joseph D'Antoni presents the basics of how to tune queries in a SQL Server environment

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.

View All

Let's get started.

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

*
*
*
*
*

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