Albert
When Using AWE, Task Manager no long reports the correct amount
of memory.

http://msdn2.microsoft.com/en-us/library/aa213764(sql.80).aspx

Use System Monitor (Performance Monitor in Microsoft Windows NT(r) 4.0)
to retrieve information on SQL Server memory usage and available memory.
Task Manager does not provide accurate memory usage information for AWE.
Therefore, the memory quoted for sqlservr.exe is not correct. To obtain
the correct amount of SQL Server memory usage, you can use the Total
Server Memory (KB) performance counter, activated through System
Monitor, or select the memory usage from sysperfinfo.

Tom

Thomas Ryan
Systems Administrator II - Database Administrator
University Medical Center

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