Microsoft

Diagnosing and Resolving Latch Contention on SQL Server

Share
Language:
English
Download
This paper discusses issues and resolutions related to page latch contention for SQL Server applications.

  • Details
    File name:
    Date Published:

    SQLServerLatchContention.docx

    6/30/2011
    Version:
    File size:

    1.0

    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.

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

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

Popular downloads

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers
Run Microsoft Update
close
moreinfo
©2013 Copyright