What does the output of this command give you?
-- Total memory consumed (including AWE) by the buffer pool--
SELECT
SUM(multi_pages_kb + virtual_memory_committed_kb +
shared_memory_committed_kb
+ awe_allocated_kb) AS [USED by BPool, kb]
FROM sys.dm_os_memory_clerks
WHERE type = 'MEMORYCLERK_SQLBUFFERPOOL'
This should tell you how much the buffer pool is using in memory if you
have AWE turned on.
Also are you using Enterprise Edition on Windows 2k8?
Z
Edward E. Ziots
CISSP, Network +, Security +
Network Engineer
Lifespan Organization
Email:[email protected]
Cell:401-639-3505
From: G.Waleed Kavalec [mailto:[email protected]]
Sent: Wednesday, March 16, 2011 4:08 PM
To: NT System Admin Issues
Subject: Getting SQL 2008 to use 16GB RAM
Due to a third party app we have some servers running W2K8 32-bit
SQL 2008 on said machines does not seem to want to use the full 16GB
The vendor has NO plans to upgrade their product. (yeah I'm looking at
YOU Sterling Software)
I have PAE and AWE turned on, and the machine is still using 3GB of the
page file and running slow.
Any suggestions?
--
__________________
Gregory Waleed Kavalec
---------------------------------------------
Fajr... It's the Believers' cup of coffee with extra caffeine.
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to [email protected]
with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to [email protected]
with the body: unsubscribe ntsysadmin
