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