Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

The analyzed query is never executed on the target server or database.

Access the Diagnose Queries window

To open the Diagnose Queries window, click the Diagnose Queries button on the SQL Doctor toolbar.

Diagnose your queries

To diagnose your queries:

  1. Click Diagnose Queries.
  2. Use the Server and Database drop-down lists to select the SQL Server instance and database on which this query either currently runs or runs in the future.
  3. Type a query in the space provided or copy and paste a query from your T-SQL files.

    Info

    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.

  4. Click Diagnose.


Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
| 

...

SQL Doctor provides complete SQL performance tuning. Learn more > >

...

Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...