SQL Doctor

Tune for performance, security, and disaster recovery
of SQL Server on-premises and in the cloud

  •  
  • 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
  • Access analysis history and view trends
  • View advice for SQL Server 2016 and 2017, Azure SQL Database, and Amazon RDS

View all servers

Quickly see the overall health of all registered servers, based on the last analysis run. From this tab, access quick links to the shared tasks for a server such as updating SQL Doctor settings, reviewing wait stats, and analyzing a query. Collect SQL Server performance information, analyze it, and determine the resolution in minutes rather than hours.

View recommendations

View a list of performance recommendations based on a full analysis based on selected criteria. The performance gain from making the suggested change, how relevant it is for the specified parameters when configuring the analysis, and the confidence SQL Doctor has in the recommendation determines the priority of the recommendation. Narrow the recommendations by targeted applications, selected performance categories, databases on the server, and more.

View server overview

Quickly see the overall health of each registered server, as of the last refresh. See a server health checklist that highlights where performance issues may be happening in real time. Review real-time, key performance metrics for each major area of the server. Display quick findings based on the values of the critical metrics to start troubleshooting performance problems immediately.

View SQL script

View the SQL text for a selected recommendation. Copy the SQL text to the clipboard to see it in a text editor or SQL Server Management Studio.

View analysis history

Access the results of every analysis stored by SQL Doctor for the registered SQL Server instances. Summaries include the name of the analyzed server, start time, total time duration, type of analysis performed, total number of recommendations, and highest priority recommendation. For each historical analysis, view recommendations, and delete and schedule an analysis.

 
Checkups

Run real-time, as-needed, and scheduled health checkups

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.

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.

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 being included in analyses.

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.

Access analysis history and view trends

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

Diagnosis

View session data

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

Pinpoint blocking and deadlocking sessions

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

Find long running jobs

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

Check security settings

Uncover many of the most common holes in security settings.

Verify disaster recovery

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

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.

Evaluate server and instance configuration

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

Find processor bottlenecks

Identify configuration settings that cause processor bottlenecks.

Check network

Diagnose issues with networking hardware and bandwidth.

SQL Query Tuning

Analyze application queries

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

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.

Evaluate custom queries

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

Check indexes

Diagnose databases indexes to determine possible performance optimizations.

Analyze wait stats

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

Problem Resolution

View prioritized list of recommendations

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

Create Executable SQL scripts

Generate the executable SQL script to enact the recommended change. Also, generate reverse scripts for quickly undoing any of the previously run SQL scripts.

Export Recommendations

Export performance recommendations to disk for convenient distribution.

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

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

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

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.

Tune SQL Server cloud databases

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

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.

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.

“SQL Doctor allows us to resolve SQL Server issues before they become problems.”
Stephen Swan, Database Administrator, Indiana Wesleyan University
(Educational Institution, USA,25 to 49 SQL Server databases) TVID 932-8E2-0DA
  •  
  •  
  •  
  •  

Resources

SQL Doctor Datasheet

Everything you need to know, all in one downloadable PDF

DOWNLOAD DATASHEET

SQL Doctor Case Study

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

DOWNLOAD CASE STUDY

SQL Doctor for the Hybrid Cloud

Learn how to tune SQL Server in the cloud

DOWNLOAD SOLUTION BRIEF

TechValidate survey results

See how a medium enterprise healthcare company uses SQL Doctor

DOWNLOAD SURVEY RESULTS

Find and Fix SQL Server Performance Problems

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

VIEW WEBCAST

Why SQL Server Health Checks Are Lifesavers

Learn the 5 reasons why SQL Server health checks are lifesavers

READ WHITEPAPER
View the list of all resources for SQL Doctor in the Resource Center.

Platform Support

Version History
  • Tune Database Instances: Microsoft SQL Server, Microsoft Azure SQL Database, and Amazon RDS SQL Server
  • Console: Microsoft Windows with Microsoft .NET Framework and web browser (Microsoft Internet Explorer)
  • Cloud: SQL Doctor runs on cloud virtual machines with Microsoft Windows -- such as such as Microsoft Azure Virtual Machine (VM ) and Amazon Elastic Compute Cloud (EC2). It tunes Microsoft SQL Server instances on cloud virtual machines -- such as Microsoft Azure VM and Amazon EC2. It tunes cloud databases (that is, Microsoft Azure SQL Database and Amazon RDS SQL Server).

SQL Doctor does not require the installation of any additional databases, dynamic-link libraries (DLLs), scripts, stored procedures, and tables on the SQL Server instances.

more details

SQL Doctor Version History

Version 3.7

  • Updated install experience
  • Support for SQL Server 2017 on Windows and Linux
  • Support for disabled TLS 1.0 and 1.1
  • Support for disabled SSL 2.0 and 3.0
  • Various minor enhancements and bug fixes

Version 3.6

  • Compatible with SQL Server on cloud VMs (Azure VM and Amazon EC2).
  • Compatible with SQL Server as managed cloud database (Azure SQL Database and Amazon RDS) including enhanced and new recommendations.
  • Optional use of Extended Events instead of SQL Trace events when relevant.
  • Minor enhancements and bug fixes.

Version 3.5

  • Updated and enhanced recommendations from SQL Server MVPs.
  • Experimental support for SQL Server 2016. Expert recommendations have been developed against, and SQL Doctor has been tested to work with, pre-release copies of SQL Server 2016.

Version 3.1

  • Installation of the SQL Toolbox framework is no longer required
  • Enhanced support for SQL 2012 - SQL doctor fully supports the use of SQL Server 2012.
  • Experimental Support for SQL Server 2014 – SQL Doctor has been tested to work with pre-release copies of SQL Server 2014.
  • Update Recommendations- Improved the user experience with enhanced recommendation content and layout
  • Usability Enhancements

Version 3.0

  • Redesigned Graphical User Interface  - A new dashboard provides a summary of all previously executed server analysis, with instant access to the corresponding recommendations
  • New Server Overview – Displays a summary of key SQL Server metrics and  notifies you of any issues that need to be addressed and provides quick findings based on your current server health
  • Analysis for Query Plan Statistics – Can now be viewed in real-time in addition to the SQL code; recommendations are provided to address any T-SQL code issues
  • Analysis for Wait Stat Statistics – Can now be viewed in near real-time with recommendations for any bottlenecks that may occur
  • Analysis for Session Statistics – Any sessions that are running are now displayed from the console with details pertaining to the command, wait times, elapsed times, affected databases and much more
  • Displays Key Server Information - Keeps tabs on your processes, network interface cards, processors , cache, memory, physical and logical disk performance, disk partitions and system information
    • Performance Metrics (CPU, memory, blocking processes, network retransmits)
    • Disaster Recovery (Full, Log backup status, suspect pages)

Version 2.0

  • Updated Recommendations: Improved the user experience with enhanced recommendation content and layout
  • Wait Statistics - New recommendations based on the analysis of wait statistics
    • CXPACKET - When a query is parallelized, one or more of the parallel threads may require more time to complete. This results in "cxpacket" waits for the remaining threads that are "waiting" for the longest running thread to complete
    • ASYNC_NETWORK_IO - This usually occurs when a client application does not efficiently process data from SQL Server over the network. The increase in async_network_io waits is caused by SQL Server waiting for the client application to process the result set
    • PAGEIOLATCH - Occurs when SQL Server waits for a data page to be read from disk into memory. This can be an indication of contention on the same pages by concurrent selects, inserts, updates and deletes, which can be magnified by IO subsystem performance issues, insufficient memory, missing indexes, out of date statistics or inefficient queries
  • Undo Scripts - Optimization scripts generated by SQL doctor (DDL,DML) can now be reverted back to what they were before the recommended changes were implemented
  • Selective Category Analysis - Easily direct SQL doctor to a specific area of concern for analysis,(i.e memory,disk,network,security,processor,deadlocks)
  • Diagnose Queries - Evaluate the performance of any query to obtain recommendations for improving its performance

Let's get started.

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

*
*
*
*
*

Purchase Now

Includes first year of maintenance.
Volume discounts available.

Add to Cart request a quote

Product Demo

See SQL Doctor
in action with a seasoned pro.

Request a Demo