Solved

Enabling Large Page Support in Windows 2008 R2

Posted on 2014-04-29
4
1,374 Views
Last Modified: 2014-05-07
How do I Enable Large Page Support in Windows 2008 R2? I will be installing Oracle 11gR2 64-bit.
0
Comment
Question by:ei00004
4 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 40030741
Check out this link: Large-Page Support
or..
   
1.    Open the folder in which Debugging Tools for Windows is installed.
2.    Start the GFlags utility.
3.    In the Global Flags dialog box, click the Image File tab.
4.    In the Image: (TAB to refresh) box, type Sqlservr.exe, and then press the TAB key.
5.    Click to select the Load image using large pages if possible check box, and then click OK
0
 

Author Comment

by:ei00004
ID: 40032093
I installed the Windows 7 and 2008 server R2 SDK but I do not see the GFlags utility. See attached.
Debugging-Toolkit.png
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 40044714
It appears you need to install Oracle first. Once that's done, the Oracle tuning guide has a few things you need to do:

http://docs.oracle.com/cd/B28359_01/win.111/b32010/tuning.htm#BCGDHBBD

Ensure your server has more physical RAM than the configured size of your SGA
Enable the "Lock Pages in Memory" security right (instructions in the tuning guide) for the service account under which the Oracle server is running
Modify the Oracle home key of the registry to specify that the instance (or all instances) should use large page support

Note that there are some additional considerations in the guide regarding whether you'd want to enable large page support, as well as some impact on the SGA, so ensure you read up before enabling it. Like any OS setting, it's not enabled by default because it's not always the best choice, but can be enabled easily if you decide it's worthwhile.

Also, note that you can install Oracle and then enable large page support later - it doesn't appear to be required that it be done first.
0

Featured Post

Promote certifications in your email signature

Has your company recently won an award or achieved a certification? They'll no doubt want to show it off. Email signature images used to promote certifications & awards can instantly establish credibility with a recipient and provide you with numerous benefits.

Join & Write a Comment

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now