Microsoft KB Archive/922118

= BUG: The User connections counter of the SQLServer:General Statistics performance object is not decremented when a Service Broker activation task is ended in SQL Server 2005 =

Article ID: 922118

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Standard X64 Edition

-



Bug #: 423675 (SQLBUDT)



SYMPTOMS
Consider the following scenario. You create a Service Broker activation endpoint in Microsoft SQL Server 2005. You use System Monitor to collect data from the User connections counter of the SQLServer:General Statistics performance object. In this scenario, you may notice that the counter is incremented for each Service Broker activation task when the task starts. However, the counter is not decremented when the task is ended.

Note If you are running the named instance of SQL Server 2005, the performance object will be named MSSQL$ :General Statistics. In this object name,  represents the name of the instance of SQL Server that you are running.



CAUSE
This issue occurs because the counter is not decremented. No memory leak exists in the user connection.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbbug kbexpertiseadvanced kbsql2005servicebroker KB922118

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.