SQL Doctor
SQL SERVER PERFORMANCE TUNING RECOMMENDATIONSSQL Doctor collects SQL Server performance information, analyzes it, and determines the resolution in minutes ratherthan hours. It leverages proven industry best practices endorsed by SQL Server MVPs to analyze the performance andto 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 andtime-consuming task. That is especially true when you need to analyze several instances for performance on an ongoingbasis. Moreover, performance bottlenecks must be identified and quickly corrected. SQL Doctor retrieves all of thenecessary 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 performancerecommendations. 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.

Start for FREE!

IDE R A . c o m

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 tounderstand 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 themodifications directly via the graphical user interface. Also,
generate reverse scripts for undoing any of the implemented
optimization scripts.

Improves Productivity SQL Doctor does all the data collection andanalysis 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 cloudenvironments; it takes it a significant step further by including
cloud-specific expert recommendations.

Easy Installation & Use SQL doctor can be installed andconfigured very quickly, typically in less than 5 minutes.

FEATURES OVERVIEW
Compatible with On-Premise and Cloud Deployments
Install and run SQL Doctor on-premise or on cloud virtualmachines (Azure VM and Amazon EC2). Connect to SQLServer as deployed as an on-premise instance, an instancehosted 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 prioritizedrecommendations in a single console for SQL Server, Azure
SQL Database, and Amazon RDS SQL Server. Configure
settings, and view the utilization of system resources andmore directly from the console.
Historical Analysis Store and easily retrieve historical data
and recommendations for trending and comparison.

I D E R A.com

Scheduled Analysis Schedule daily or weekly check-ups.
Performance Category Analysis Allows distinct areas of SQL serverperformance 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 andgain 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.

877 GO IDERA 464.3372

EMEA +44 1628 684 400

TWITTER twitter.com/Idera_Software

APAC +61 1300 307 211

FACEBOOK facebook.com/IderaSoftware

MEXICO +52 (55) 8421-7980

LINKEDIN linkedin.com/company/idera-software

BRAZIL +55 (11) 3280-1159

SQL Doctor will help the most experienced
DBAS quickly pinpoint performance problems, and it teaches
novice DBAs the techniques to be senior level.
It’s a must have SQL performance tool.

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

Long Running Jobs, Transactions Identify jobs andtransactions that may be running longer than usual
Processor Identify configuration settings that cause
processor bottlenecks

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

Memory Pinpoint memory usage & configuration
performance problems

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

Disk Uncover a multitude of disk and databaseconfiguration and performance issues

Index Optimization Diagnose indexes to determine
possible performance optimizations

Network Diagnose issues with networking hardware or bandwidth

Server Configuration Examine Windows andSQL Server configuration settings

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

Security Settings Uncover many of the mostcommon holes in security settings
Blocking and Deadlocking Determine which
sessions are blocking or are involved in a deadlock

Cloud-specific Recommendations Access enhanced and newexpert 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.

SYSTEM REQUIREMENTS
ConsoleSupported SQL Server instances• Windows Server 2003 SP3, Windows Server 2008, WindowsServer 2008 R2, Windows 7 SP1+, Windows 8, Windows 10,Windows Server 2012, Windows Server 2012 R2, WindowsServer 2016; also on Azure VM and Amazon EC2• SQL Server 2005, SQL Server 2008, SQL Server 2008
R2, SQL Server 2012, SQL Server 2014, SQL Server2016• Microsoft .NET Framework: 4.0• Amazon RDS SQL Server• Azure SQL Database• Web Browser: Microsoft Internet Explorer 7.0+

IDE R A . c o m