Monday, March 26, 2012

Lock pages in memory.

If SQL Server is running on Local System account, does it automatically
have the "Lock Pages in memory" right or does this have to be manually
set?
If manual, which account is the Local System, in the list of domain accounts
that appears in gpedit.msc.
Any help greatly appreciated.Help me here<g>
I need to know this, in order to tell whether my sql server local
system account is managing awe memory properly.
Please...
"Stressed" <k@.c.co.uk> wrote in message
news:eV5Du$BYDHA.736@.TK2MSFTNGP09.phx.gbl...
> If SQL Server is running on Local System account, does it automatically
> have the "Lock Pages in memory" right or does this have to be manually
> set?
> If manual, which account is the Local System, in the list of domain
accounts
> that appears in gpedit.msc.
> Any help greatly appreciated.
>|||One more thing,
If the "lock pages in memory " permission is not granted you should have
seen error in the errorlog.
In the SQL Server log, you will see the following message:
Cannot use Address Windowing Extensions because lock memory privilege was
not granted.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Thanks for the reply, was very helpful.
"Yih-Yoon Lee [MS]" <yihyoonl@.online.microsoft.com> wrote in message
news:doqK3sTYDHA.304@.cpmsftngxa06.phx.gbl...
> One more thing,
> If the "lock pages in memory " permission is not granted you should have
> seen error in the errorlog.
> In the SQL Server log, you will see the following message:
> Cannot use Address Windowing Extensions because lock memory privilege was
> not granted.
> Sincerely,
> Yih-Yoon Lee [Microsoft]
> Microsoft SQL Server Support
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>

No comments:

Post a Comment