AWE on Windows 64 Bit

Hi,
By having 6GB memory on Windows 2003 64 bit:
1) Do I have to add /PAE switch to boot.ini ?
2) What about AWE option for SQL Server, it must be enabled?
Thanks in advance,
Leila
Is SQL Server 64 bit? If so, you don't need any of those settings (AWE will be ignored if set).
However, you might benefit if service account has "lock pages in memory" privileges.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:Ol%23hWXRhHHA.984@.TK2MSFTNGP04.phx.gbl...
> Hi,
> By having 6GB memory on Windows 2003 64 bit:
> 1) Do I have to add /PAE switch to boot.ini ?
> 2) What about AWE option for SQL Server, it must be enabled?
> Thanks in advance,
> Leila
>
|||Thanks Tibor,
Yes SQL Server is 64 bit. If it's 32 bit AWE is required?
Is /3GB switch still beneficial for SQL Server in 64 bit environment?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ut0F$fRhHHA.960@.TK2MSFTNGP03.phx.gbl...
> Is SQL Server 64 bit? If so, you don't need any of those settings (AWE
> will be ignored if set). However, you might benefit if service account has
> "lock pages in memory" privileges.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:Ol%23hWXRhHHA.984@.TK2MSFTNGP04.phx.gbl...
>
|||> Is /3GB switch still beneficial for SQL Server in 64 bit environment?
No, such a switch is irrelevant in 64 bit.

> If it's 32 bit AWE is required?
Yes, if you want to utilize > 4GB memory. PAE is not needed, though Note, this applies to 32 bit SQL
Server in 64 bit OS (x64, architecture).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Leila" <Leilas@.hotpop.com> wrote in message news:OlP9cnRhHHA.4132@.TK2MSFTNGP05.phx.gbl...
> Thanks Tibor,
> Yes SQL Server is 64 bit. If it's 32 bit AWE is required?
> Is /3GB switch still beneficial for SQL Server in 64 bit environment?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ut0F$fRhHHA.960@.TK2MSFTNGP03.phx.gbl...
>
|||> No, such a switch is irrelevant in 64 bit.
Could you please explain it? AFAIK, 3GB switch forces OS to use only 1GB for
kernel mode. Therefore still it must be useable for 64 bit. Is it wrong?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OFpOezRhHHA.4444@.TK2MSFTNGP04.phx.gbl...
> No, such a switch is irrelevant in 64 bit.
>
> Yes, if you want to utilize > 4GB memory. PAE is not needed, though Note,
> this applies to 32 bit SQL Server in 64 bit OS (x64, architecture).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OlP9cnRhHHA.4132@.TK2MSFTNGP05.phx.gbl...
>
|||32 bit has a limitation of only being able to directly address 4GB of
memory. Beyond that it requires PAE for the OS and AWE for the apps to use
the extra memory. By default 32 bit apps can only use 2 of that 4GB and the
OS uses 2GB. With 64 bit the directly addressable memory is way beyond what
the app or OS will use in the near future. As such there is no need for the
/3GB since any 64 bit app can address all it wants as can the OS.
Andrew J. Kelly SQL MVP
"Leila" <Leilas@.hotpop.com> wrote in message
news:uWXaG%23RhHHA.984@.TK2MSFTNGP04.phx.gbl...
> Could you please explain it? AFAIK, 3GB switch forces OS to use only 1GB
> for kernel mode. Therefore still it must be useable for 64 bit. Is it
> wrong?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:OFpOezRhHHA.4444@.TK2MSFTNGP04.phx.gbl...
>