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.
- Visually tune complex SQL queries.
- Profile databases with wait-time analysis.
- Load test in simulated production environments
-
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.
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.)
SQL Query Tuner
Datasheet
Everything you need to know, all in one downloadable PDF.
Visually Tune
Complex Queries
Learn how to visually tune
complex queries with
SQL Query Tuner
Compare Editions of
SQL Diagnostic Manager
Compare the features of SQL
Diagnostic Manager, SQL Workload
Analysis, and SQL Query Tuner
Why Should You Use Visual
SQL Tuning Diagrams
Learn about using visual SQL
tuning diagrams to improve
database performance
SQL Server
Query Tuning
Compare the features of SQL
Diagnostic Manager, SQL Workload
Analysis, and SQL Query Tuner
SQL Syntax and
Query Performance
Joe Celck presents syntax and query
principles to produce good SQL
and a maintainable schema