Page History

SQL Doctor provides the following new features and fixed issues.

3.

...

7 New features

Data Collection

To collect query-related data, SQL Doctor 3.6 now supports the use of Extended Events, allowing for optimal data collection during analysis.

Microsoft SQL Azure and Amazon RDS compatibility

SQL Doctor installation is compatible with Microsoft Windows Azure and Amazon EC2 environments.

...

General

SQL Doctor is able to analyze and

...

generate recommendations for SQL

...

Server 2017 instances running on Windows or Linux operating systems.

3.

...

7 Fixed issues

...

Analysis

SQL Doctor

...

Deadlock Report

SQL Doctor is no longer showing error while running the deadlock report.

Blocking Recommendation

SQL Doctor is no longer displaying an error when viewing the details of the recommendation addressing a blocking condition.

Analyzing a server

...

is able to correctly limit analysis to a single database as specified in the Analysis wizard.

Users are no longer able to remove instances that have analysis in progress.

Optimization Scripts

Optimization scripts now include schema information to ensure proper execution of the script.

Optimization scripts are no longer generating the ·The embedded resource was not found..." error.