Re: Explain

From: "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@xxxxxxxxxx>
Date: Mon, 4 Apr 2005 18:20:04 +0200

> 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

.

References:
- Explain
  - From: Rogers
- RE: Explain
  - From: Rogers
- Re: Explain
  - From: Andrew J. Kelly
- Re: Explain
  - From: Rogers

Prev by Date: Re: Explain
Next by Date: Appricated.
Previous by thread: Re: Explain
Next by thread: Statistics.
Index(es):
- Date
- Thread

Relevant Pages

RE: Explain
... Can any one let me know the difference between user connections and not the ... number of users that currently are connected to SQL Server. ... > Server affects its performance, you may want to keep an eye on this counter. ...
(microsoft.public.sqlserver.clients)
Re: Enterprise manager security?
... using a special account. ... permissions) for user connections to the server running SQL Server. ... Security can be implemented and secured based on NT groups. ...
(microsoft.public.sqlserver.security)
Explain
... Counter Name: SQL Server General Statistics: User Connections ... Prev by Date: ...
(microsoft.public.sqlserver.clients)
Re: Decode an error message
... SQL Server reported SQL message 207, ... I've ruled out legacy clients, ... > What SMS component is generating this error? ... >> connect and that there are enough user connections available. ...
(microsoft.public.sms.setup)
Re: Decode an error message
... SQL Server reported SQL message 207, ... I've ruled out legacy clients, ... > What SMS component is generating this error? ... >> connect and that there are enough user connections available. ...
(microsoft.public.sms.setup)