What are your memory settings (in the properties tab for the server in
EM)?

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



This email and any files transmitted within it are private and confidential.
If you are not the intended recipient, this email and any attachments within it have been transmitted to you in error.
You are prohibited from using, copying, distributing or otherwise using the information contained within this email.
Nothing in this email message amounts to a contractual or legal commitment on the part of Optilan unless confirmed by a communication signed on behalf of the company.
Any email cannot be guaranteed to be secure, error free or free from viruses. Although every possible care is taken by Optilan, Optilan does not accept any liability whatsoever for any loss or damage which may be caused as a result of the transmission of this message by email.


MS Sql Server LazyDBA home page