Microsoft KB Archive/255786

From BetaArchive Wiki
Knowledge Base

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

Article ID: 255786

Article Last Modified on 10/16/2002


  • Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q255786

BUG #: 57630 (SQLBUG_70)


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.


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.


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


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