Diagnosing and Resolving Spinlock Contention on SQL Server

  • Article

Authors: Mike Ruthruff, Ewan Fairweather

Contributors: Fabricio Voznika, Jack Richins, Thomas Kejser

Technical Reviewers:

Prem Mehra, Steve Howard, Paul S. Randal, SQLskills.com, Kun Chen, Gus Apostol, Sanjay Mishra, Alexei Khalyako

Published: July 2011

Abstract:

This
paper describes how to identify and resolve spinlock contention issues observed
when running SQL Server 2008 applications on high concurrency systems with
certain workloads.

Executive Summary:

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 https://go.microsoft.com/fwlink/?LinkId=223366.