Monday, March 26, 2012

lock pages in memory and AWE

Hi,
I noticed that SQL Service account needs 'lock pages in memory' permission
to enable Address Windowing Extensions (AWE). Is there any risk in granting
this permission to SQL Server and SQL Agent service accounts?
ThanksOnly if your SQL server gets hacked/compromised. Then again, you are
usually hosed if that happens anyway.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alex" <alim@.rogers.com> wrote in message
news:uWfXe8lYGHA.2376@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I noticed that SQL Service account needs 'lock pages in memory' permission
> to enable Address Windowing Extensions (AWE). Is there any risk in
> granting this permission to SQL Server and SQL Agent service accounts?
> Thanks
>

No comments:

Post a Comment