You should also check the network utilization of the web server itself
using netmon or another tool, the firewall and router logs, and NAT
settings. There is also the possibility that you are experiencing some
sort of DNS attack or other network error. It may not be the db server
at all.

I would start at the outside and work my way in, in this case. If the
sql box is running fine, chances are it's not the sql box causing the
issue, but an outside source.


Jeff D. Metcalf
IT Director
Cplus Sales & Service
864 801 9003

The absence of evidence is not the evidence of absence.


-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x96157363.[Email address protected]
Sent: Thursday, March 29, 2007 7:43 AM
To: LazyDBA Discussion
Subject: site slow

I need advice from any of you experts on this issue.

We have a box with SQL Server 2000 on back-end with website pointing to
that box. The machine has Windows 2003 Server Enterprise w/Service Pack
1, 8GB of RAM.

I enabled AWE and allocated 6GB for SQL Server.

Yet when website is extremely slow, when I look at the Task Manager on
that box SQL Server always uses only under 200MB. Any help appreciated.



Thanks,



Albert Frazer

Home Decor Products, Inc

www.hdpi.com <http://www.hdpi.com>

732-593-3637 (office)

732-570-4465 (cell)





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page