How many concurrent connections will SQL Server actively handle on a mid range multi-processor server before connection numbers starts becoming a problem?

-- Anonymous, June 25, 2002

Answers

Mark,

I don't know what to tell you other then, "It depends!"

SQL Server 2000 can be configured with up to 32,767 connections. I've seen connection problems with a few as 1 connection. ;-)

The variables are how much memory, how many processors, how fast the processors are, how often the connections are hitting the server, what the queries are that are running, and on and on. (Not to mention licensing issues.)

The buzz on the usenet forums seems to be that SQL Server 2000 can support in the hundreds of connections.

Good Luck,

Eric

-- Anonymous, June 25, 2002