Troubleshooting SQL Query Analyzer

Here is a problem that you may encounter when using SQL Query Analyzer to execute a script:

• Showplan does not return a plan for Transact-SQL statements referencing objects created within the SHOWPLAN statement. If SHOWPLAN is set to ON, the query will not execute and the object will not be created. Any references to the object will fail with an error indicating that the object does not exist. You can trace the TSQL:SQL:BatchStarting and Performance:Execution Plan events in SQL Profiler while executing the Transact-SQL statements to see the plan.

Here is a problem that you may encounter when using SQL Query Analyzer to tune a database for a query:

• Unable to recommend indexes because the query did not reference any tunable tables. This problem was caused by at least one of the following scenarios.
  • The query did not reference any tunable tables.
    
    
  • The query has a syntax error or is invalid.
    
    
  • You are working in the wrong database.
    
    
  • You are referencing a temporary table.

For more information, see Index Tuning Wizard.