Contents
Chapter 1 An Introduction to Query Tuning and Optimization
Generating Candidate Execution Plans
Assessing the Cost of Each Plan
Query Execution and Plan Caching
Getting Plans from a Trace or the Plan Cache
Removing Plans from the Plan Cache
Chapter 2 Troubleshooting Queries
sys.dm_exec_requests and sys.dm_exec_sessions
Understanding statement_start_offset and statement_end_offset
Get Microsoft SQL Server 2014 Query Tuning & Optimization now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.