Friday, March 9, 2012

maximum number of concurrent logins ?

what is the maximum number of concurrent logins MS SQL can
support ? does it depend on the resources of the server ?
assuming the server has almost unlimited resources, is
there a max number of concurrent users that can log in?Hi,
SQL Server can support a maximum of 32767 user connections.
Does it depend on the resources of the server ?
As you said, Resouce will also play because each user connecting requires
physical memory.
Assuming the server has almost unlimited resources, is there a max number of
concurrent users that can log in?
32767
Thanks
Hari
MCDBA
"new2sql" <anonymous@.discussions.microsoft.com> wrote in message
news:810801c3e871$97bb7860$a601280a@.phx.gbl...
> what is the maximum number of concurrent logins MS SQL can
> support ? does it depend on the resources of the server ?
> assuming the server has almost unlimited resources, is
> there a max number of concurrent users that can log in?

No comments:

Post a Comment