SQL Server experiences a high load, and blocking problems may occur when you check a page in in SharePoint Server 2007

SQL Server experiences a high load, and blocking problems may occur when you check a page in in SharePoint Server 2007

Article ID : 949008
Last Review : March 18, 2008
Revision : 1.0

SYMPTOMS

In Microsoft Office SharePoint Server 2007, you check a page in. When you do this, a query for all the documents in the library is implemented. When this occurs, Microsoft SQL Server experiences a high load, and blocking problems may occur.

Back to the top

CAUSE

This issue occurs because the query pulls back all the rows in the library instead of the one row that you updated before you checked the page in.

Back to the top

RESOLUTION

To resolve this problem, apply hotfix 948947.

For more information about hotfix 948947, click the following article number to view the article in the Microsoft Knowledge Base:

948947 (/Feedback.aspx?kbNumber=948947/) Description of the SharePoint Server 2007 hotfix package: February 21, 2008

Back to the top


APPLIES TO
• Microsoft Office SharePoint Server 2007

Back to the top

Keywords: 
kbtshoot kbexpertiseadvanced kbfix kbprb KB949008

Back to the top

 

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
Microsoft Corporation. All rights reserved. Terms of Use | Trademarks


You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Leave a Reply

*
To prove that you're not a bot, enter this code
Anti-Spam Image