Re: Explain

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@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)
  • 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)
  • Re: MS Access linked tables SQL Server
    ... Protocol Encryption selection so that all connections to the SQL Server are ...
    (microsoft.public.sqlserver.security)