Microsoft Download Center Archive

Diagnosing and Resolving Spinlock Contention on SQL Server

  • Published:
  • Version: 1.0
  • Category: Document
  • Language: English

This paper discusses issues and resolutions related to spinlock contention for SQL Server applications.

  • This paper provides in-depth information about the methodology the Microsoft SQL Server Customer Advisory Team (SQLCAT) team uses to identify and resolve issues related to spinlock contention observed when running SQL Server 2008 and SQL Server 2008 R2 applications on high-concurrency systems.

Files

Status: Deleted

This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to August 2020.

FileSize
SQLServerSpinlockContention.docx
SHA1: 7221b1879cf15bd94e256330a28ab513f1c91f86
225 KB
SQLServerSpinlockContention.exe
SHA1: 496fe9b9f3beb3c583494233061ed48890b608c9
298 KB
SQLServerSpinlockContention.pdf
SHA1: bebab64b873dde05b201dc984e48a66f348959db
486 KB

System Requirements

Operating Systems: Windows 7, Windows Server 2008 R2, Windows Vista

    • For DOCX files: Microsoft Word or Word Viewer.
    • For PDF files: Adobe Acrobat Reader.
    • For CHM files within EXE file: No special software required.

Installation Instructions

    1. To start the download, click the Download button next to the desired file.
    2. Do one of the following:
      • To start the installation immediately, click Open.
      • To copy the download to your computer for installation at a later time, click Save.
      • To cancel the installation, click Cancel.
    For the CHM file:
    If you are unable to view the CHM file when you click Open, try the download again but select Save and choose where you want to save the file. Then use one of the following methods to open the CHM:

    Method 1
    1. Double-click the .chm file.
    2. In the Open File-Security Warning dialog box, click to clear the Always ask before opening this file check box.
    3. Click Open.

    Method 2
    1. Right–click the .chm file, and then click Properties.
    2. Click Unblock.
    3. Double-click the .chm file to open the file.