When you checked Task Manager what was the CPU utilization and how much
of that was SQLservr?

You should start looking for Bottle Necks such as Disk I/O, Network
Utilization, etc.

Also you may have a SP that is doing something strange.

Rick Romack
SQL Server Support
IT Data Center, State Compensation Insurance Fund
415-581-8022

-----Original Message-----
From: Albert Frazer
[mailto:mssqldba-ezmlmshield-x96157363.[Email address protected]
Sent: Thursday, March 29, 2007 4: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