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

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 page latch 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 April 2023.

Files
SQLServerLatchContention.docx SHA1: 9b30b28614939e9f321ccc45614e761dce94cead Size: 1.02 MB
SQLServerLatchContention.exe
SQLServerLatchContention.pdf SHA1: b9902fb71c2436e384a91eb1c1dd210f37f0c122 Size: 1.35 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

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

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.