Datasheet : SQL Doctor

SQL Server Performance Tuning Recommendations

SQL Doctor collects SQL Server performance information, analyzes it, and determines the resolution in minutes rather than hours. It leverages proven industry best practices endorsed by SQL Server MVPs to analyze the performance and to provide recommendations. It targets some of the most common areas of performance problems, such as queries, server configuration, security, database objects, memory, wait statistics, query plans, and much more. It is compatible with SQL Server on-premise, on cloud virtual machines, and as managed cloud databases. It is a must-have time-saving tool for database administrators, developers, and analysts who need to maintain and improve database performance.

Why SQL Doctor?

SQL Server administrators, developers, and analysts are under intense pressure to maintain high levels of database and application performance. Diagnosing and resolving performance issues can be an overwhelming and time-consuming task. That is especially true when you need to analyze several instances for performance on an ongoing basis. Moreover, performance bottlenecks must be identified and quickly corrected. 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. Whether you are a novice or expert at performance tuning, SQL Doctor makes your daily tasks easier. Additionally, it provides educational resources to support the performance recommendations. It is not just a performance analyzer; it is a great tool for educating the user about tuning.

SQL Doctor diagnoses and provides the cure for what ails your SQL Server on-premise, in the cloud, and as a managed cloud database.

Product Highlights

  • Easily monitor and improve the performance of SQL Server, Azure and AWS instances
  • Instantly locate real-time performance issues with Quick Findings
  • Improve performance with updated recommendations for SQL Server 2016, Azure SQL Database, and Amazon RDS
  • Generate executable scripts to optimize performance
  • View trends from history of analysis recommendations

Key Benefits

Optimizes SQL Server Performance Receive easy to understand performance and tuning recommendations including index usage, query syntax enhancements, configuration changes, etc.

Provides Executable Scripts Review and run executable scripts to implement the recommendations. Perform the modifications directly via the graphical user interface. Also, generate reverse scripts for undoing any of the implemented optimization scripts.

Easy Installation & Use SQL Doctor can be installed and configured very quickly, typically in less than 5 minutes.

Improves Productivity SQL Doctor does all the data collection and analysis allowing database professionals to move on to other more important tasks like actually fixing the problem.

Provides Single, Familiar Tool for On-Premise & Hybrid Cloud Improve the performance for on-premise databases, databases on cloud virtual machines, and managed cloud databases. SQL Doctor does not simply include support for these cloud environments; it takes it a significant step further by including cloud-specific expert recommendations.

Features Overview

Compatible with On-Premise and Cloud Deployments Install and run SQL Doctor on-premise or on cloud virtual machines (Azure VM and Amazon EC2). Connect to SQL Server as deployed as an on-premise instance, an instance hosted on cloud virtual machines (Azure VM & Amazon EC2), and a database-as-a-service (Azure SQL Database & Amazon RDS).

Console Analyze performance data and display prioritized recommendations in a single console for SQL Server, Azure SQL Database, and Amazon RDS SQL Server. Configure settings, and view the utilization of system resources and more directly from the console.

Historical Analysis Store and easily retrieve historical data and recommendations for trending and comparison.

Scheduled Analysis Schedule daily or weekly check-ups.

Performance Category Analysis Allows distinct areas of SQL server performance to be analyzed individually (memory, security, indexes, disk, network, processor, etc).

Export Capabilities Export performance recommendations for easy distribution.

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

Extended Events and SQL Trace Events To collect data, SQL Doctor supports extended events and SQL Trace events. It automatically uses the best method available depending on the SQL Server version, or it can be directed to use SQL Trace events always.

Recommendations and Impact Analysis

Wait Stats For SQL Server, Azure SQL Database, and Amazon RDS SQL Server, analyze the most common wait statistics that cause SQL Server query delays (that is, cxpacket, pageiolatch, and async_network_io).

Disaster Recovery Identifies SQL Server database integrity issues and recovery methods that may leave the database in a potentially unrecoverable state

SQL Query Tuning Identify up to 40 of the most common query syntax inefficiencies

Index Optimization Diagnose indexes to determine possible performance optimizations

Server Configuration Examine Windows and SQL Server configuration settings

Security Settings Uncover many of the most common holes in security settings

Blocking and Deadlocking Determine which sessions are blocking or are involved in a deadlock

Long Running Jobs, Transactions Identify jobs and transactions that may be running longer than usual

Processor Identify configuration settings that cause processor bottlenecks

Memory Pinpoint memory usage & configuration performance problems

Disk Uncover a multitude of disk and database configuration and performance issues

Network Diagnose issues with networking hardware or bandwidth

Query Plan Statistics Displays statistical details about query plan and additionally delivers recommendations for improving their performance

Cloud-specific Recommendations Access enhanced and new expert recommendations that are unique to database-as-a-service. These recommendations include 19 for Azure SQL Database, 59 for Amazon RDS SQL Server, and 92 for both platforms.

Download This Datasheet Start a FREE Trial of SQL Doctor
Share This
Contact IDERA:
Call toll-free in North America
1-877-464-3372
Call International
+1-713-523-4433