Hi All
I would like to confirm with you guys: If i have 64 bit sql server with 20G
of memory, should I mark 'Use AWE to allocate memory' on 'server
properties'-->'memory' window?

If the OS is 64 bit, I would not automatically enable AWE, though generally
it doesn't do any harm. I did run into a case where you may want to enable
it. The case was that there was a different program running on the box, and
the program was behaving badly in grabbing a huge amount of memory, and it
was forcing the SQL process to page much of its original working set out.

Linchi

"Gene." wrote:

> Hi All
> I would like to confirm with you guys: If i have 64 bit sql server with 20G
> of memory, should I mark 'Use AWE to allocate memory' on 'server
> properties'-->'memory' window?

No. The 64bit edition of SQL Server does not support AWE. It isn't
required on 64bit systems.

Denny

On Wed, 16 Jul 2008 09:08:01 -0700, Gene.
<Gene@discussions.microsoft.com> wrote:

>Hi All
>I would like to confirm with you guys: If i have 64 bit sql server with 20G
>of memory, should I mark 'Use AWE to allocate memory' on 'server
>properties'-->'memory' window?

No, AWE is not needed for 64 bit. But you should set the account that sql
server is running under to have Lock Pages In Memory rights and set a MAX
Memory setting to leave a few GB's for the OS and anything else that may
need it.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Gene." <Gene@discussions.microsoft.com> wrote in message
news:976E8666-A228-473F-AD03-A78385C76727@microsoft.com...
> Hi All
> I would like to confirm with you guys: If i have 64 bit sql server with
> 20G
> of memory, should I mark 'Use AWE to allocate memory' on 'server
> properties'-->'memory' window?

Oops! I meant to say 'Lock page in memory' instead of AWE. -- Linchi

"Linchi Shea" wrote:

> If the OS is 64 bit, I would not automatically enable AWE, though generally
> it doesn't do any harm. I did run into a case where you may want to enable
> it. The case was that there was a different program running on the box, and
> the program was behaving badly in grabbing a huge amount of memory, and it
> was forcing the SQL process to page much of its original working set out.
>
> Linchi
>
> "Gene." wrote:
>
> > Hi All
> > I would like to confirm with you guys: If i have 64 bit sql server with 20G
> > of memory, should I mark 'Use AWE to allocate memory' on 'server
> > properties'-->'memory' window?

If you have enterprise, and have enough RAM that you don't need to
swap to page file, then yes. If you don't have enterprise edition
don't bother as on Enterprise Edition will support that setting.

Denny

On Wed, 16 Jul 2008 12:52:04 -0700, Linchi Shea
<LinchiShea@discussions.microsoft.com> wrote:

>Oops! I meant to say 'Lock page in memory' instead of AWE. -- Linchi
>
>"Linchi Shea" wrote:
>
>> If the OS is 64 bit, I would not automatically enable AWE, though generally
>> it doesn't do any harm. I did run into a case where you may want to enable
>> it. The case was that there was a different program running on the box, and
>> the program was behaving badly in grabbing a huge amount of memory, and it
>> was forcing the SQL process to page much of its original working set out.
>>
>> Linchi
>>
>> "Gene." wrote:
>>
>> > Hi All
>> > I would like to confirm with you guys: If i have 64 bit sql server with 20G
>> > of memory, should I mark 'Use AWE to allocate memory' on 'server
>> > properties'-->'memory' window?