QBS Slogan
QBS Slogan
You are not currently logged in

SQL Doctor  by Idera

SQL doctor is the database administrators best friend! What would normally take a DBA hours collecting performance information, analysing it and determining the resolution can be now be accomplished by SQL doctor in minutes! SQL doctor leverages proven industry best practices endorsed by SQL Server MVPs to analyse the performance of SQL Server and provide recommendations for improving its performance. Furthermore, 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. It is a must-have time saving tool for quality assurance, database administrators, analysts, developers and individuals who are tasked with maintaining and improving SQL server performance.

Key Features:

  • Server overview - instantly highlights where performance problems are occurring. In addition, displays performance metrics (for processes, network interface cards, processor, processor cache, memory, disk, system information) in near real-time
  • Session data - easily view all sessions that are currently active with detailed performance metrics collected from Dynamic Management Views (DMV); recommendations are provided to help improve performance
  • Historical analysis - store and easily retrieve historical data and recommendations for trending and comparison
  • Export capabilities - export performance recommendations for easy distribution
  • Performance category analysis - allows distinct areas of SQL Server performance to be analysed individually, e.g., memory, security, indexes, disk, network, and processor
  • Diagnose queries - evaluate the most troublesome queries and gain immediate suggestions to improve their performance
  • Scheduled analysis - schedule daily or weekly check-ups.

Recommendations and impact analysis:

  • Wait Stats: Analyses the most popular wait statistics which cause SQL server query delays (cxpacket, pageio-latch, async_network_io).
  • Disaster Recovery: Identifies SQL Server database integrity issues and recovery methods that may leave the database in a potentially unrecoverable state.
  • 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.
  • Index Optimisation: Diagnose indexes to determine possible performance optimisations.
  • 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 and 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.

For further details or pricing information, please call +44 (0)20 8733 7101 or email sales@qbssoftware.com