The Diagnose Queries window helps you save time by analyzing the queries you care about without having to wait for a full analysis to complete. When SQL Doctor diagnoses a query, you receive performance recommendations without actually executing it.
When you click the diagnose button, SQL Doctor parses the T-SQL and bases the analysis and resultant recommendations on the estimated execution plans of the database selected.
The analyzed query is never executed on the target server or database. |
To open the Diagnose Queries window, click the Diagnose Queries button on the SQL Doctor toolbar.
To diagnose your queries:
Type a query in the space provided or copy and paste a query from your T-SQL files.
To validate the syntax of your query, use a tool like SQL Server Management Studio. SQL Doctor may be unable to generate estimated execution plans for queries that contain bad syntax. |
| | | | | | | |