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
