SQL Server Connections

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

Answers

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


Moderation questions? read the FAQ