RE: Connection issues
From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 09/17/04
- Next message: eriphaz001_at_yahoo.com: "Re: Connection error - please help"
- Previous message: Chris Themi: "Starting, connecting to MSDE from command line"
- In reply to: Jeff: "Connection issues"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 17 Sep 2004 01:31:06 -0700
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
>
>
>
- Next message: eriphaz001_at_yahoo.com: "Re: Connection error - please help"
- Previous message: Chris Themi: "Starting, connecting to MSDE from command line"
- In reply to: Jeff: "Connection issues"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
