sql server connect: How many concurrent sessions can SQL 2000 take?

[quoted text, click to view]

Theoretically maximum is 32,767 user connections. Actual number will vary
based on edition of SQL Server 2000 installed and hardware in use.

Steve

Steve,

how about for SQL 2000 Enterprise?

the reason I am asking is because I had an issue where we
were getting asp errors/access denied during heavy traffic
to our web servers/db servers.

Our web server and db server are on 2 sep. machines.
Pbviously, the web server connects to the db server.
The web server is on wind.2003.
anyways, that specific day, we got heavy traffic and some
of the connections were timing out. I looked at the SQL
processes in Enterprise Manager and saw that lots of
proccesses were sleeping, so i am not sure what to make of
this. I looked at perfmon and saw that the hardware was up
to spec with no issues...
any ideas? is this a app/coding issue?
thanks


[quoted text, click to view]