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

    Категории