This is 2004188 KB=2GB (2004188/1000 then /1000 again) that is quite a small buffer pool which could be some of the reason you might be seeing paging.
Do you have the Counters Page-File %useage Peak% and %useage% handy? What do those look like? 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: Friday, March 18, 2011 5:42 PM To: NT System Admin Issues Subject: Re: Getting SQL 2008 to use 16GB RAM It tells me 2004188 Which makes NO sense. AWE is on. /3GB is on. PAE is on. ? On Thu, Mar 17, 2011 at 7:36 AM, Ziots, Edward <[email protected]> wrote: 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] <mailto: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 -- __________________ 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
