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



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