Concurrent connections/sessions for SQL 2000

How many concurrent sessions can SQL 2000 take?
thanks"Jeff" <anonymous@.discussions.microsoft.com> wrote in message
news:c2a701c489f7$b69bd590$a501280a@.phx.gbl...
> How many concurrent sessions can SQL 2000 take?
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

>--Original Message--
>"Jeff" <anonymous@.discussions.microsoft.com> wrote in
message
>news:c2a701c489f7$b69bd590$a501280a@.phx.gbl...
>Theoretically maximum is 32,767 user connections. Actual
number will vary
>based on edition of SQL Server 2000 installed and
hardware in use.
>Steve
>
>.
>