Information générale
Catégorie:
Applications Internet
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement