PAE is an OS switch - it does nothing to help an individual application. It just lets the OS address all the RAM
AWE just lets the application use different "chunks" of 4GB address space. However a 32 bit application is still limited to 4GB of address space at a time. It can just vary where that 4GB of address space points to. And /3GB just lets the application use more of it's 4GB of address space (whilst limiting what the kernel can use to 1GB). Since you've limited the kernel to 1GB of address space, maybe it is kernel data that is now being pushed to page file, since there is not enough address space anymore? If you are sure that you are paging (no evidence provided yet), and you are sure that it is SQL Server that is paging, can you stand up a separate SQL Server (running the x64 version of SQL Server) on a Windows Server x64 server. Tell your 32bit app server to connect to the remote x64 SQL Server. Cheers Ken From: G.Waleed Kavalec [mailto:[email protected]] Sent: Saturday, 19 March 2011 5:42 AM 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]<mailto:[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<tel:401-639-3505> From: G.Waleed Kavalec [mailto:[email protected]<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]<mailto:[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]<mailto:[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]<mailto:[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
