Chapter 7. Tuning and Optimizing Analysis

Terms you'll need to understand:

• Query Analyzer

• SQL Profiler

• System Monitor

• Trace

• Filter

• Execution plan

• Query Optimizer

Techniques you'll need to master:

• Viewing current activity

• Tracing activity over time

• Utilizing the System Monitor

• Tracing operations with the SQL Profiler

• Diagnosing execution plans

• Troubleshooting locking behavior