Hi all,
I am looking at doing the MCDBA certification.
Does any one have any training guides they suggest?
Web links or resources that might help?
General tips?
Is 2005 certification avialable yet?
Cheers,
AdamThe 2005 track is a little different. You may want to start here:
http://www.microsoft.com/learning/mcp/mcts/sql/
Andrew J. Kelly SQL MVP
"Adam J Knight" <adam.jknight@.optusnet.com.au> wrote in message
news:uzWsAJ7%23FHA.504@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I am looking at doing the MCDBA certification.
> Does any one have any training guides they suggest?
> Web links or resources that might help?
> General tips?
> Is 2005 certification avialable yet?
> Cheers,
> Adam
>sql
Showing posts with label resources. Show all posts
Showing posts with label resources. Show all posts
Friday, March 23, 2012
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?
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?
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...
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...
quote:
> 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?
Subscribe to:
Posts (Atom)