Re: Explain

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C5C92E7-84FF-404F-987E-86A2BA6832B6@xxxxxxxxxxxxxxxx
> 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.
>>


.

Relevant Pages

  • Re: Dot Net 2.0 or SQL Server 2005 problem?
    ... Assume the SQLExpress set up is OK, whther you can actually access the SQL ... After installing SQL Server Express, if you did not add any SQL login ... Configuration' and set the option to 'Using Both TCP/IP and Named Pipes'. ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS SQL 2005 Configuration ???
    ... It sounds like you are running SQLExpress, not SQLServer. ... I don't have SQL Express, so I can't replicate what you're seeing. ... "Surface Area Configuration for Services and Connections", ... SQL Server Browser). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server 2005 Express Connection
    ... Some people have been having issues when trying to make remote connections ... networking protocols are disabled by default in SQL Server Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • ADO data control, proper use
    ... When opening the program there is currently five connections to SQL ... connections for a single program to have open with SQL Server. ... Is there a way to close the ado data control connection after a ...
    (microsoft.public.vb.database.ado)
Loading