SQL Doctor

Have a SQL Assistant on Hand with

SQL Doctor

  • New and enhanced Expert Recommendations to help improve performance
  • Dashboard exposes performance metrics in real-time
  • "Quick Findings" instantly locates SQL performance issues
  • Executable scripts are generated to optimize performance
  • Stored history of analysis recommendations for trending

פרולוג'יק היא המפיצה הרישמית של מוצרי IDERA בישראל.
כמו כן פרולוג'יק מספקת חבילת מוצר מושלמת הכוללת אינטגרציה, ליווי והדרכה.

sql-diagnostic-manager-repository-dashboard-screenshot
  • New and enhanced Expert Recommendations to help improve performance
  • Dashboard exposes performance metrics in real-time
  • "Quick Findings" instantly locates SQL performance issues
  • Executable scripts are generated to optimize performance
  • Stored history of analysis recommendations for trending

See Detailed Performance Metrics

Analyze the performance of SQL Server databases and receive tuning recommendations for resolving them in minutes as opposed to hours. SQL Doctor targets some of the most common areas of SQL Server performance problems, such as queries, server configuration, security, database objects, memory, wait statistics, query plans, and much more.

Locate Issues via "Quick Findings"

SQL Doctor Instantly highlights where performance threatening issues are occurring, displaying metrics in real-time for processes, network interface cards, processor, processor cache, memory, disk, and system information.

Enhanced Expert Recommendations

Leverage the latest proven industry best practices endorsed by SQL Server MVPs to analyze the performance of SQL Server. Get expert recommendations including index usage, query syntax enhancements and configuration changes with a patented ranking system that shows the highest performance improvement options first. Expert recommendations have been developed against, and SQL Doctor has been tested to work with, pre-release copies of SQL Server 2016.

Executable Scripts Available

SQL Doctor provides executable scripts of the recommendations that can be reviewed and implemented directly in the tool. Generate “undo” scripts for quickly reversing any of the optimization scripts which have been previously implemented.

Historical Analysis

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

Environment Analysis

Discover Integrity Issues

Identifies SQL Server database integrity issues and highlights recovery methods which may leave the database in a potentially unrecoverable state.

Index Optimization

Diagnose indexes to determine possible performance optimizations.

Server Configuration

Examine Windows and SQL Server configuration settings.

Processor

Identify configuration settings that cause processor bottlenecks.

Security Settings

Uncover many of the most common holes in security settings.

Deeper Analytics

Wait Stats

Analyzes the most popular wait statistics which cause SQL server query delays (cxpacket, pageio­latch, async_network_io).

Blocking and Deadlocking

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

Long Running Jobs

Identify jobs and transactions that may be running longer than usual

Network

Diagnose issues with networking hardware or bandwidth

Session Data

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

Problem Resolution

Query Plan Statistics

Displays statistical details about query plan and delivers recommendations for improving their performance.

SQL Query Tuning

Identify up to 40 of the most common query syntax inefficiencies then tune to improve efficiency.

Diagnose Queries

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

Export Capabilities

Export performance recommendations for easy distribution.

Schedule Tune Ups

Schedule daily or weekly check-ups to keep your SQL Servers performing in top shape.

Console and Services

  • x86 and x64: Windows Server 2008 R2, Windows Server 2008, Windows Server 2003 SP3, Windows Vista SP1+, Windows 7 SP1+, Windows 8 and 8.1, Windows 10
  • .NET 3.5

Supported SQL Server instances

  • SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 ,SQL Server 2012, SQL Server 2014, SQL Server 2016