max connections

hello everybody,
does anyone knows the max connections the sql server can work with. i need to know about the sql server capability according to hardware limits ( for exe:how many connection can the sql manege on 2 cpu's computer with 2.gb ram, etc')
thanks
Ruby
Hi
The number of connections would be limited by what you are licenced for. If
you are looking for a figure for the number of connections per second this
will mainly be limited by the capabilities of your network, although if you
expect this to be high you should probably be looking at connection pooling.
You should also look at the work carried out by each person as this will
effect the time they are connected and your hardware maybe incapable of
sustaining a reasonable level of service to the users.
For maximum capacity settings see:
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
Your hardware vendor may be able to give you some idea of what you can
expect and your should specify your requirements as part of the tender
process. This should also allow you to benchmark your application on their
hardware as part of the acceptance process.
John
"ruby" <anonymous@.discussions.microsoft.com> wrote in message
news:9245A3AA-C494-413A-A4B8-6B58C71DA9DC@.microsoft.com...
> hello everybody,
> does anyone knows the max connections the sql server can work with. i need
to know about the sql server capability according to hardware limits ( for
exe:how many connection can the sql manege on 2 cpu's computer with 2.gb
ram, etc')
> thanks
> Ruby