SQL Doctor について

パフォーマンスの問題を修正するためのアドバイスや推奨事項を提供

SQL Doctorは、SQL Serverのパフォーマンスを分析し、そのパフォーマンスを向上させるための推奨事項を提供するために、SQL ServerのMVPで承認、実績のある業界のベストプラクティスを活用しています。さらにSQL Doctorは、クエリ、サーバー構成、セキュリティ、データベース·オブジェクト、メモリ、Waitの統計、クエリプラン、およびこのようなSQL Serverのパフォーマンスの問題の最も一般的な分野を対象としています。SQLサーバーパフォーマンスのメンテナンスと改善を必要とする品質管理者、データベース管理者、アナリスト、開発者等にとって時間節約のための必須ツールです。

SQL Doctor Features

  • Checkups
    • Run real-time, as-needed, and scheduled health checkups - Schedule a regular analysis for an instance to track the health of SQL Server environments. Schedule daily or weekly check-ups to keep SQL Servers performing in top shape.
    • View enterprise and server summaries - Based on the last analysis run, quickly see the overall health of all registered servers. Drill down to a selected instance, analysis, server, and recommendation.
    • Select analysis categories - Choose any combination of categories: blocking processes, database configuration, deadlocks, disk, disaster recovery, index optimization, long-running jobs, memory, network, open transactions, and more.
    • Access analysis history and view trends - Access the results of every analysis stored for registered instances. View summaries and drill down to details.
    • Limit the analysis to specified databases and applications - Choose which database or application workload to include in the analysis. Block recommendations per instance to reduce analysis noise for undesirable changes. Block databases from the analysis.
  • Diagnosis
    • View session data - Quickly view all sessions that are currently active with detailed performance metrics collected from Dynamic Management Views (DMV).
    • Collect extended and SQL Trace events - Collect data using extended events and SQL Trace events. Automatically use the best method available depending on the SQL Server version, or decide to use SQL Trace events always.
    • Pinpoint blocking and deadlocking sessions - Determine which sessions are blocking or are involved in a deadlock.
    • Evaluate server and instance configuration - Examine configuration settings of SQL Server and the Windows operating system.
    • Find long running jobs - Identify jobs and transactions that may be running longer than usual.
    • Find processor bottlenecks - Identify configuration settings that cause processor bottlenecks.
    • Check security settings - Uncover many of the most common holes in security settings.
    • Check network - Diagnose issues with networking hardware and bandwidth.
    • Verify disaster recovery - Identify database integrity issues and recovery methods that may leave the database in a potentially unrecoverable state.
  • SQL Query Tuning
    • Analyze application queries - Evaluate the most troublesome queries and gain immediate suggestions to improve their performance.
    • Check indexes - Diagnose databases indexes to determine possible performance optimizations.
    • Explore query plan statistics - Display statistical details about query plans For SQL Server, Azure SQL Database, and Amazon RDS SQL Server and deliver recommendations to improve their performance.
    • Analyze wait stats - Analyze the most popular wait statistics that cause query delays for SQL Server, Azure SQL Database and Amazon RDS SQL Server.
    • Evaluate custom queries - Analyze custom queries by parsing the T-SQL script without actually executing the query to receive recommendations.
  • Problem Resolution
    • View prioritized list of recommendations - Display the highest performance improvement options first according to a patented ranking system.
    • Export Recommendations - Export performance recommendations to disk for convenient distribution.
    • Create Executable SQL scripts - Generate executable SQL scripts to enact the recommended change. Also, generate reverse scripts to quickly undo the previously run SQL scripts.
    • Access Cloud-specific Recommendations - Access enhanced and new expert recommendations that are unique to the managed cloud databases Azure SQL Database and Amazon RDS SQL Server.
  • Cloud
    • Install on cloud virtual machines - Run SQL Doctor on cloud virtual machines with Windows – such as Microsoft Azure Virtual Machines (VMs) and Amazon Elastic Compute Cloud (EC2).
    • Tune SQL Server cloud databases - Tune the SQL Server cloud databases Azure SQL Database and Amazon RDS for SQL Server.
    • Access mapped cloud drives - SQL Doctor can access cloud storage that is mapped as network drives or removable drives on Microsoft Windows. For example, map to Azure Blob Storage and Amazon Simple Storage Service (S3).
    • View cloud-specific recommendations - Access enhanced and new expert recommendations that are unique to the managed SQL Server cloud databases Azure SQL Database and Amazon RDS for SQL Server.
    • Tune SQL Server on cloud virtual machines - Tune instances of SQL Server running on cloud virtual machines – such as Microsoft Azure VMs and Amazon EC2.
    • Monitor hybrid environments with a single tool - Avoid learning new tools by using the same tuning tool for SQL Server on-premises on physical and virtual machines, in the cloud on virtual machines, and the cloud as managed databases.