Question about AWE.

SQL2K SP3
From reading BOL, to enable AWE, I should simply need to:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', MyMax
RECONFIGURE
GO
And then start the SQL services. But a coworker of mine seems to think that
there's more to it then that. That SQL won't really be using AWE until we do
this something else. The best part is he's not sure what that something else
is. I think there's nothing else, but wanted to verify if I could.
TIA, ChrisR
Hi,Chris
http://www.sql-server-performance.com/awe_memory.asp
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:312ACADD-F513-4D8F-B5D8-F69C2D2E9138@.microsoft.com...
> SQL2K SP3
> From reading BOL, to enable AWE, I should simply need to:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', MyMax
> RECONFIGURE
> GO
> And then start the SQL services. But a coworker of mine seems to think
> that
> there's more to it then that. That SQL won't really be using AWE until we
> do
> this something else. The best part is he's not sure what that something
> else
> is. I think there's nothing else, but wanted to verify if I could.
> TIA, ChrisR
|||And also http://www.sqlservercentral.com/colu...adventures.asp
See Lock Pages in memory priv.
Don't forget that if you install Sql2000sp4 you must get a hotfix otherwise
SQL will use half the memory (bug in the base SP4)
Paul
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eW7yW6TPGHA.3924@.TK2MSFTNGP14.phx.gbl...
> Hi,Chris
> http://www.sql-server-performance.com/awe_memory.asp
>
>
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:312ACADD-F513-4D8F-B5D8-F69C2D2E9138@.microsoft.com...
>