Diagnosing and Resolving Latch Contention on SQL Server

This paper discusses issues and resolutions related to page latch contention for SQL Server applications.
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:




    Date Published:


    File Size:

    1.4 MB

    1.0 MB

    1.1 MB

      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.
  • Supported Operating System

    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.
      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.
Site feedback

What category would you like to give web site feedback on?

Rate your level of satisfaction with this web page today: