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

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.

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.

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: