MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition

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