For your convenience Apress has placed some of the front
matter material after the index. Please use the Bookmarks
and Contents at a Glance links to access them.
SQL Server 2012 Query
Performance Tuning
Grant Fritchey
iii
Contents at a Glance
About the Author ...................................................................................................... xxiii
About the Technical Reviewer .................................................................................... xxv
Acknowledgments .................................................................................................... xxvII
Introduction ............................................................................................................... xxix
Chapter 1: SQL Query Performance Tuning ■ ..................................................................1
Chapter 2: System Performance Analysis ■ .................................................................15
Chapter 3: SQL Query Performance Analysis ■ .............................................................59
Chapter 4: Index Analysis ■ ..........................................................................................99
Chapter 5: Database Engine Tuning Advisor ■ ............................................................149
Chapter 6: Lookup Analysis ■ .....................................................................................163
Chapter 7: Statistics Analysis ■ .................................................................................175
Chapter 8: Fragmentation Analysis ■ .........................................................................211
Chapter 9: Execution Plan Cache Analysis ■ ..............................................................241
Chapter 10: Query Recompilation ■ ............................................................................281
Chapter 11: Query Design Analysis ■ .........................................................................313
Chapter 12: Blocking Analysis ■ ................................................................................349
Chapter 13: Deadlock Analysis ■ ................................................................................393
■ Contents at a GlanCe
iv
Chapter 14: Cursor Cost Analysis ■ ............................................................................407
Chapter 15: Database Performance Testing ■ ............................................................429
Chapter 16: Database Workload Optimization ■ .........................................................437
Chapter 17: SQL Server Optimization Checklist ■ ......................................................469
Index ...........................................................................................................................489
