Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

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.

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

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

• 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.