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 (922118)
The information in this article 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
- Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
- Microsoft SQL Server 2005 Enterprise X64 Edition
- SQL Server 2005 Standard Edition for Itanium-based Systems
- Microsoft SQL Server 2005 Standard X64 Edition
Bug #: 423675 (SQLBUDT)
SYMPTOMSConsider 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$InstanceName:General Statistics. In this object name, InstanceName represents the name of the instance of SQL Server that you are running.CAUSEThis issue occurs because the counter is not decremented. No memory leak exists in the user connection.STATUSMicrosoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
| Modification Type: | Major | Last Reviewed: | 7/11/2006 |
|---|
| Keywords: | kbBug kbExpertiseAdvanced kbtshoot kbsql2005servicebroker KB922118 kbAudDeveloper kbAudITPRO |
|---|
|