SQL Server Connectionsgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
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.
-- Anonymous, July 05, 2001
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,
-- Anonymous, July 06, 2001