Have a SQL Assistant on Hand with

SQL Doctor

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
No credit card required! Fully functional for 14 days

Buy Now

Includes first year of maintenance.

Add to Cart

Need pricing options?

Request a quote for SMB or multi-license discount pricing.

Request a Quote

Live Product Demo

See SQL Doctor in action with a seasoned pro.

Request a Demo

Methodist Hospitals of Dallas reduced issues concerning backups, indexes, queries, resources, SQL Server settings, and workloads by more than 80% since using SQL Doctor.
Jeff Jantrakul, Application Database Administrator, Methodist Hospitals of Dallas (Medium Enterprise, Health Care), USA.
TechValidate A16-EA0-3A1, 21B-792-25F, F4B-9ED-4EE, 5C6-0EE-F45, B6A-F55-D96, DF5-B8E-A36.