Office Communication Server 2007 R2 and SQL Server report frequent SQL deadlocks

Article ID: 981247 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When the presence load is heavy and the rate of requests for polling subscription is very high, Microsoft Office Communications Server 2007 R2 and Microsoft SQL Server report frequent SQL deadlocks. Additionally, requests from Office Communications Server that are queued in the database are dropped.
Note If lots of group chat clients are deployed, this problem is more likely to occur. This is because this topology has frequent requests for polling subscription.
Back to the top | Give Feedback

CAUSE

This problem is caused by an SQL deadlock in the RtcBatchQueryCategories stored procedure.
Back to the top | Give Feedback

RESOLUTION

To fix this problem, apply the following update:
979857
(http://support.microsoft.com/kb/979857/ )
Description of the Office Communications Server 2007 R2 update
Back to the top | Give Feedback

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top | Give Feedback

Properties

Article ID: 981247 - Last Review: October 6, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Office Communications Server 2007 R2 Standard Edition
  • Microsoft Office Communications Server 2007 R2 Enterprise Edition
Keywords: 
kbfix kbqfe kbexpertiseinter kbsurveynew kbprb KB981247
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top