Query Analysis

Query Execution Process
Overview of the SQL Execution Plan
Deep Dive on the SQL Execution Plan
Querying SQL Statements That Affect Performance Most
Checking Blocked Statements

Parent topic: Query Performance Optimization