General information
Category:
Internet applications
>Scalability means that it can get LARGE without problems.
>
>For example, I think that the limit on SQL (pronounced by one of my
>acquaintances as SQUEAL) is about 200 simultaneous connections.
I'm not sure this is entirely correct.....
SQL Server uses 32k of memory for each connection, so there is an implicit limit due to the amount of memory you have. Since this is considered part fo the overhead allocation of SQL Server memory, your procedure and data caches will decrease in size with more connections added to the server. Thus, I'm not saying your wrong, either....(s)
>Oracle does not have this limit.
I would think 200 connections is a lot for any platform unless you are "throwing hardware" at the problem, which SQL Server can do as well (and cheaper, from what I'm told (g)).
Just IMHO,
Scot.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only