Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

Lock pages in memory

Does a reboot of box required after granting the sql service account in lock paegs in memory? Pls help

SQL Server  64 bit
windows server x64
0
shadyc
Asked:
shadyc
  • 3
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> SQL Server  64 bit   windows server x64

Locking pages in memory is not required on 64-bit operating systems. Ref below:

http://technet.microsoft.com/en-us/library/ms190730.aspx
http://technet.microsoft.com/en-us/library/ms187499.aspx

AWE and Lock Pages in Memory needs to be configured in 32 bit machines to make use of memory greater than 4 GB. Because 32 bit machines Windows Addressing can't access more than 4 GB and hence need to enable AWE to use memory greater than 4 GB.

Hope this clarifies.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
shadyc,
   If I have clarified your question, then this question needs to be closed assigning points to me and not to be deleted.

Kindly confirm.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Thanks Vee_Mod and shadyc
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now