SQL Server Connections

greenspun.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

Moderation questions? read the FAQ