RE: site slow

RE: site slow

 

  

Does your web code use a timer? Search MS for a hotfix.

Is debug set to = true?

What makes you think this has anything to do with sql??

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