EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Electronic resources] نسخه متنی

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