You should also run a trace and look at the execution times of the
queries, as it might not be SQL at fault!


-----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


DISCLAIMER
Any opinions expressed in this email are those of the individual and not necessarily the Company.
This email and any file transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited.
If you have received this email in error please notify the Swinton Business Systems Service Desk via email to [Email address protected] including a copy of this message. Please then delete this email and destroy any copies of it.
Swinton Group Limited may monitor the content of all emails sent via its network for the purposes of ensuring compliance with its policies and procedures.
As part of Swinton Group Limited security policy, this email has been virus scanned.
Swinton Group Limited, registered in England 756681, is connected for the purposes of the Insurance Companies Regulations 1981 to MMA insurance plc.
Registered office: Swinton House, 6 Great Marlborough street, Manchester, M1 5SW.
Swinton Group Limited is authorised and regulated by the Financial Services Authority.


MS Sql Server LazyDBA home page