Managing Performance and Troubleshooting Commands

You can view all one or more commands or details of their query plans with the ttSQLCmdCacheInfo and ttSQLCmdQueryPlan built-in procedures. Use the query plan information to monitor and troubleshoot your queries.

Viewing commands and query plans can help you perform the following:

• Detect updates or deletes that are not using an index scan.

• Monitor query plans of running queries to ensure all plans are optimized.

• Detect applications that do not prepare SQL statements or that re-prepare the same statement multiple times.

• Detect the percentage of space used in the command cache for performance evaluation.