Authors: Mike Ruthruff, Ewan Fairweather
Contributors: Fabricio Voznika, Jack Richins, Thomas Kejser
Prem Mehra, Steve Howard, Paul S. Randal, SQLskills.com, Kun Chen, Gus Apostol, Sanjay Mishra, Alexei Khalyako
Published: July 2011
paper describes how to identify and resolve spinlock contention issues observed
when running SQL Server 2008 applications on high concurrency systems with
Welcome to the Diagnosing and Resolving Spinlock Contention on SQL Server paper. While working with mission critical customer systems the Microsoft SQL Server Customer Advisory Team (SQLCAT) have developed a methodology which we use to identify and resolve particular resource contention issues observed when running SQL Server 2008 and SQL Server 2008 R2 on high concurrency systems.
We created this guide to provide in-depth information about identifying and resolving resource contention issues related to spinlock contention observed when running SQL Server 2008 applications on high concurrency systems with certain workloads.
The recommendations and best practices documented here are based on real-world experience during the development and deployment of real world OLTP systems.
To download a copy of this guide in chm, pdf, or docx form, go to http://go.microsoft.com/fwlink/?LinkId=223366.
Diagnosing and Resolving Spinlock Contention on SQL Server sqlcat.com/.../2011
Pingback from SQL Server: Diagnosing and Resolving Latch & Spinlock Contention … « notes from a software alchemist
Pingback from New whitepapers on latches and spinlocks published | devblogging.com