Explain

Counter Name: SQL Server General Statistics: User Connections
This shows the number of user connections, not the number of users that
currently are connected to SQL Server. Since the number of users using SQL
Server affects its performance, you may want to keep an eye on this counter.
Can any one let me know the difference between user connections and not the
number of users that currently are connected to SQL Server.
This shows the number of user connections, not the number of users that
currently are connected to SQL Server. Since the number of users using SQL
Server affects its performance, you may want to keep an eye on this counter.
"Rogers" wrote:

> Counter Name: SQL Server General Statistics: User Connections
> This shows the number of user connections, not the number of users that
> currently are connected to SQL Server. Since the number of users using SQL
> Server affects its performance, you may want to keep an eye on this counter.
>
|||In SQL 2000 any SPIDs below 50 are system connections. These are connections
that SQL Server uses to manage the server. Any SPID over 50 is a user
connection but may include things like SQL Agent, DTS etc. The description
below is not the best in my opinion but what it is trying to say is that you
can have a single user (person or application) that may have more than one
connection.
Andrew J. Kelly SQL MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:7C5C92E7-84FF-404F-987E-86A2BA6832B6@.microsoft.com...[vbcol=seagreen]
> Can any one let me know the difference between user connections and not
> the
> number of users that currently are connected to SQL Server.
> This shows the number of user connections, not the number of users that
> currently are connected to SQL Server. Since the number of users using SQL
> Server affects its performance, you may want to keep an eye on this
> counter.
>
> "Rogers" wrote:
|||What I want to ask like in the sp_configure there is user connection, is that
means how many users can connected simultaneously?
"Andrew J. Kelly" wrote:

> In SQL 2000 any SPIDs below 50 are system connections. These are connections
> that SQL Server uses to manage the server. Any SPID over 50 is a user
> connection but may include things like SQL Agent, DTS etc. The description
> below is not the best in my opinion but what it is trying to say is that you
> can have a single user (person or application) that may have more than one
> connection.
> --
> Andrew J. Kelly SQL MVP
>
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:7C5C92E7-84FF-404F-987E-86A2BA6832B6@.microsoft.com...
>
>
|||> What I want to ask like in the sp_configure there is user connection, is
that
> means how many users can connected simultaneously?
The Perfmon counter shows the number of users connected to the system. Use
the sp_configure user connections option to specify the maximum number of
simultaneous user connections allowed on SQL Server.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com