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
