xvi Contents
Combining System Monitor and Profiler Traces ..................568
Replaying Traces
.........................................569
Using SQLDiag to Collect Performance Data
. . . . . . . . . . . . . . . . . . .570
Locks, Blocking, and Deadlocks
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .571
Locking
...............................................572
Blocking
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .572
Deadlocks
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .573
Transaction Isolation Levels
.................................573
Lock Escalation
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .574
Lock Compatibility
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .574
Detecting and Resolving Locking Problems
.....................575
Guide to the DYNAMIC Management Views (DMVs)
. . . . . . . . . . . . . . .578
Partitioning
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .581
Horizontal Partitioning
....................................581
Vertical Partitioning
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .582
Filegroups
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .582
Selecting a Partition Key and Number of Partitions
...............583
Partition Function
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .584
Partition Scheme
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .584
Moving Data between Partitions
...........................585
Performance Data Collection
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .586
Performance Data Collection Explained
. . . . . . . . . . . . . . . . . . . . . . .586
Management Data Warehouse
...............................587
Configuring MDW
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .587
Configuring Data Collection
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .593
Data Collection Caching
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .594
Management Data Warehouse Reports
. . . . . . . . . . . . . . . . . . . . . . . .595
Resource Governor
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .596
Resource Governor Concepts
...............................597
Resource Pools
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .597
Workload Groups
......................................599
Classification Function
..................................599
Validate Configuration
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .600
Resource Governor Summary
...............................600
Summary of Exam Objectives
..................................601
Exam Objectives Fast Track
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .601
Exam Objectives Frequently Asked Questions
......................603
Self Test
..................................................604
Self Test Quick Answer Key
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .609