Connection issues

Hi all
how about for SQL 2000 Enterprise?
what are the concurrent connections?
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
Hi
If a process is sleeping, a connection is established, but no commands have
been sent for execution. This is normal.
During heavy usage, you can check that there is no blocking by running
SP_who2 on the SQL server. Gernerally, a web box will be the limitatzion,
long before a SQL box runs out of power, unless you have an application that
is really badly designed and developed.
Regards
Mike
"Jeff" wrote:

> Hi all
> how about for SQL 2000 Enterprise?
> what are the concurrent connections?
> 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
>
>