SQL Server Connectionsgreenspun.com : LUSENET : SQL Server Database Administration : One Thread |
Eric,How many connections does SQL Server 7.0/2000 support? If this answer is variable depending on multiple factors, could you explain? Does SQL Server use a connection pooling scheme? Also, do you think it is better for a web application serving 75,000+ users to open and close connections within local scope or to bind a single connection for a whole session (per user)?
Thanks for your help.
Ramil
-- Anonymous, July 05, 2001
Ramil,You can configure SQL Server to not put a limit the maximum concurrent user connections.
I would design my web application to open and close connections.
Hope this helps,
Eric
-- Anonymous, July 06, 2001