If AWE is turned on and you got 16GIG of RAM and you are using Windows 2008 32bit
Look at this accordingly http://msdn.microsoft.com/en-us/library/ms178067(v=SQL.100).aspx http://sqlserver-training.com/physical-memory-limit-windows-server-2008/ If its Windows 2008 Standard then the OS is limited for 4GB in 32bit mode, if its Enterprise its 64GB. \ Also this post on enabling /PAE switch in Windows 2008 http://sqlserver-training.com/how-to-enable-pae-in-windows-server-2008 Also do you have LOCK Pages in Memory set for the SQL Server Account? ( User Privilege) Also look at this one: Enabling AWE for SQL Server. http://msdn.microsoft.com/en-us/library/ms190673.aspx 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: Tuesday, March 22, 2011 4:24 PM To: NT System Admin Issues Subject: Re: Getting SQL 2008 to use 16GB RAM AWE is turned on in this case. Ed - Still getting the Counters you asked about. Ken - we are going to try the two-server trick. On Mon, Mar 21, 2011 at 1:10 PM, Brad DeHart <[email protected]> wrote: Through SQL Server Management Studio, connect to the DB server in question, right click on the DB server name in the Object Explorer pane and select properties. Select the Memory page, and you'll see a "Use AWE to allocate memory" option(which is unselected by default). Thanks, Brad -----Original Message----- From: Ben Scott [mailto:[email protected]] Sent: Saturday, March 19, 2011 6:25 AM To: NT System Admin Issues Subject: Re: Getting SQL 2008 to use 16GB RAM On Sat, Mar 19, 2011 at 1:50 AM, Ken Schaefer <[email protected]> wrote: > AWE just lets the application use different "chunks" of 4GB address space. Something I've been wondering about: Does one have to do anything special to get MS-SQL 2008 to actually use AWE? Is any tuning involved? (I'm not a database guy.) -- Ben ~ 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 Kern Health Systems Confidentiality Statement: This email and any attachments are legally privileged and can contain business proprietary and/or confidential information intended for a specific individual and purpose. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party unless required to do so by law or regulation and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of these documents is strictly prohibited. If you have received this information in error, please notify the sender immediately and arrange for the return or destruction of these documents. ~ 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
