SQL Performance Tuning

Database Tuning for SQL Server, Azure SQL Database, and Amazon RDS for SQL Server

SQL Doctor

Database Performance Tuning

Tune Database Performance, Disaster Recovery, and Security with Expert Recommendations

Diagnosing and resolving performance issues can be an overwhelming and time-consuming task. SQL Doctor retrieves all of the necessary information, analyzes the results, pinpoints potential problems, and provides ranked recommendations that help you to resolve those issues on your instances.

SQL Doctor
  • Tune SQL Server for physical, virtual, and cloud environments.
  • View a summary of the health of the entire enterprise and a selected server.
  • Display prioritized list of performance optimization recommendations.
  • Generate executable SQL scripts to optimize performance.
open-quote

SQL Doctor points you directly to the location where you have trouble with SQL Server, it provides an explanation, and it suggests how to fix or avoid the problem.

Tony Wang, Application Developer, Quarto Group Software Systems Inc

(small business, computer software, Canada)

SQL Doctor allows us to resolve SQL Server issues before they become problems.

Stephen Swan, Database Administrator, Indiana Wesleyan University

(educational institution, USA)

SQL Doctor provides us with an easy and quick way to get an up to date analysis of our SQL Server environment.

Derek Darrow, Database Administrator, Wunderman

(medium enterprise, media and entertainment, USA)

SQL Doctor results in better SQL Server performance without having to invest in infrastructure upgrades.

Steve Gockley, Database Administrator, Boostability

(medium enterprise, computer services, USA)
open-quote
  • SQL Health Check
    Schedule real-time health checks

    Schedule a regular analysis for an instance to track the health of SQL Server environments. Schedule daily or weekly check-ups to keep SQL Servers performing in top shape.

  • Server Health Monitoring
    View Enterprise and Server Summaries

    Based on the last analysis run, quickly see the overall health of all registered servers. Drill down to a selected instance, analysis, server, and recommendation.

  • SQL Server Audit
    Select analysis categories

    Choose any combination of categories: blocking processes, database configuration, deadlocks, disk, disaster recovery, index optimization, long-running jobs, memory, network, open transactions, and more.

  • SQL Server Audit Log
    Access analysis history and view trends

    Access the results of every analysis stored for registered instances. View summaries and drill down to details.

  • Database Audit
    Limit the analysis to specified databases and applications

    Choose which database or application workload to include in the analysis. Block recommendations per instance to reduce analysis noise for undesirable changes. Block databases from the analysis.

  • Server Metrics
    View session data

    Quickly view all sessions that are currently active with detailed performance metrics collected from Dynamic
    Management Views (DMV).

  • SQL Trace
    Collect extended and SQL trace events

    Collect data using extended events and SQL Trace events. Automatically use the best method available depending on the SQL Server version, or decide to use SQL Trace events always.

  • SQL Deadlock
    Pinpoint blocking and deadlocking sessions

    Determine which sessions are blocking or are involved in a deadlock.

  • Server Configuration
    Evaluate server and instance configuration

    Examine configuration settings of SQL Server and the Windows operating system.

  • SQL Server Agent Job
    Find long running jobs

    Identify jobs and transactions that may be running longer than usual.

  • SQL Server Agent Job
    Find long-running jobs

    Identify configuration settings that cause processor bottlenecks.

  • Performance Bottleneck
    Find processor bottlenecks

    Identify configuration settings that cause processor bottlenecks.

  • SQL Server Security
    Check security settings

    Uncover many of the most common holes in security settings.

  • Network Monitoring
    Check network

    Diagnose issues with networking hardware and bandwidth.

  • SQL Server Disaster Recovery
    Verify disaster recovery

    Identify database integrity issues and recovery methods that may leave the database in a potentially unrecoverable state

  • Application Query Performance
    Analyze application queries

    Evaluate the most troublesome queries and gain immediate suggestions to improve their performance.

  • Check Index Fragmentation
    Check indexes

    Diagnose databases indexes to determine possible performance optimizations.

  • Query Plan
    Explore query plan statistics

    Display statistical details about query plans For SQL Server, Azure SQL Database, and Amazon RDS SQL Server and deliver recommendations to improve their performance.

  • SQL Server Wait Stats
    Analyze wait stats

    Analyze the most popular wait statistics that cause query delays for SQL Server, Azure SQL Database and Amazon RDS SQL Server.

  • T-SQL Query
    Evaluate custom queries

    Analyze custom queries by parsing the T-SQL script without actually executing the query to receive recommendations.

  • SQL Server Performance Tips
    View prioritized list of recommendations

    Display the highest performance improvement options first according to a patented ranking system.

  • SQL Server Performance Recommendations
    Export Recommendations

    Export performance recommendations to disk for convenient distribution.

  • SQL Script Generator
    Create Executable SQL scripts

    Generate executable SQL scripts to enact the recommended change. Also, generate reverse scripts to quickly undo the previously run SQL scripts.

  • Cloud Database Performance
    Access Cloud-specific Recommendations

    Access enhanced and new expert recommendations that are unique to the managed cloud databases Azure SQL Database and Amazon RDS SQL Server.

  • Cloud Virtual Machines
    nstall on cloud virtual machines

    Run SQL Doctor on cloud virtual machines with Windows – such as Microsoft Azure Virtual Machines (VMs) and Amazon Elastic Compute Cloud (EC2).

  • Cloud Performance
    Tune SQL Server cloud databases

    Tune the SQL Server cloud databases Azure SQL Database and Amazon RDS for SQL Server.

  • Cloud Drives
    Access mapped cloud drives

    SQL Doctor can access cloud storage that is mapped as network drives or removable drives on Microsoft Windows. For example, map to Azure Blob Storage and Amazon Simple Storage Service (S3).

  • SQL Server Cloud Database
    View cloud-specific recommendations

    Access enhanced and new expert recommendations that are unique to the managed SQL Server cloud databases Azure SQL Database and Amazon RDS for SQL Server.

  • SQL Server on Cloud Virtual Machines
    Tune SQL Server on cloud virtual machines

    Tune instances of SQL Server running on cloud virtual machines – such as Microsoft Azure VMs and Amazon EC2.

  • Monitor SQL Server Hybrid Environments
    Monitor hybrid environments with a single tool

    Avoid learning new tools by using the same tuning tool for SQL Server on-premises on physical and virtual machines, in the cloud on virtual machines, and the cloud as managed databases.

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.

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

Ready to see how SQL Doctor can help you monitor the performance of your entire SQL Server environment?

Datasheet

SQL Doctor
Datasheet

Everything you need to know, all in one downloadable PDF

Casestudy

SQL Doctor
Case Study

See how an IT consulting firm tuned SQL Server with SQL Doctor

White Paper

SQL Doctor for
the Hybrid Cloud

Learn how to tune SQL Server in the cloud

Play

Value of
SQL Doctor

Learn about the benefits of SQL Doctor for you and your organization

Webcast

Find and Fix SQL Server Performance Problems

Learn how to find and fix problems with the performance of SQL Server

White Paper

Why SQL Server Health
Checks are Lifesavers

Learn the 5 reasons why SQL Server health checks are lifesavers

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