Microsoft KB Archive/255786

= BUG: Performance Monitor May not Show Correct Number of User Connections =

Article ID: 255786

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q255786



BUG #: 57630 (SQLBUG_70)



SYMPTOMS
In Microsoft SQL Server 7.0, when an Administrator limits user connections and sets the user connections configuration option to a fixed value, the correct number of user connections may not display in the Performance Monitor. If more than the configured number of connections attempts to connect, the user connections counter in the Performance Monitor incorrectly scales upward even though some connections exceed the maximum configured value and do not actually connect. The connections in the Performance Monitor are not related to any actual connections and therefore never disconnect.



WORKAROUND
If you set the SQL Server user connections configuration option to zero (0 - unlimited user connections) then the value is logged in Performance Monitor correctly.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.



MORE INFORMATION
Setting the user connections configuration option to a fixed value may cause a gradual increment in the number of phantom user connections logged in the Performance Monitor. The increment of phantom user connections does not occur if the user connection configuration value is set to unlimited.

The sp_who system stored procedure in SQL Server always reports the correct number of user connections. So, this problem occurs only with Performance Monitor logging.

Keywords: kbbug kbpending KB255786

-

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

© Microsoft Corporation. All rights reserved.