Solved

Memory Question in Server 2008 Enterprise Edition (32-bt)

Posted on 2011-03-09
8
547 Views
Last Modified: 2012-05-11
We have SQL running on the box and it is continuously experiencing memory exhaustion. I enabled AWE config and when I did system info it is showing as follows. And this server has Memory (RAM) of 16.0GB.

Total Physical Memory:     3,325 MB
Available Physical Memory: 145 MB

Any thoughts on how to fix this issue?

Thank you.
0
Comment
Question by:mmoya
  • 4
  • 3
8 Comments
 
LVL 1

Expert Comment

by:IWillHelp
ID: 35084592
The limits of memory available and used by Server 2008 Enterprise 32 bit systems are dependant on the boot Physical Address Extension.

Windows automatically enables PAE if DEP is enabled on a computer that supports hardware-enabled DEP, or if the computer is configured for hot-add memory devices in memory ranges beyond 4 GB. If the computer does not support hardware-enabled DEP or is not configured for hot-add memory devices in memory ranges beyond 4 GB, PAE must be explicitly enabled.

To explicitly enable PAE, use the following BCDEdit /set command to set the pae boot entry option:

bcdedit /set [{ID}] pae ForceEnable
IF DEP is enabled, PAE cannot be disabled. Use the following BCDEdit /set commands to disable both DEP and PAE:

bcdedit /set [{ID}] nx AlwaysOff
bcdedit /set [{ID}] pae ForceDisable

Once PAE is enabled properly and rebooted, 32 bit Enterprise systems should see all of your 16Gig of memory installed.
0
 

Author Comment

by:mmoya
ID: 35084620
bcdedit is not a builtin tool. Where can I get that from? Appreciate your help!
0
 

Author Comment

by:mmoya
ID: 35084631
And how would I check if DEP is enabled?
0
 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 35084659
IWillHelp is correct PAE is the switch that allows for more memory to be allocated to the server OS.
0
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 1

Expert Comment

by:IWillHelp
ID: 35084892
BCDEdit is a command line tool that is included in Server 2008.  It is located within the System32 folder.

If you goto your CMD, and simply type "BCDEdit" you should get your Boot Loader and Boot Manager Properties.  If it returns as unknown command, then check on Microsoft for the proper install.  I believe it was on the original install, but it may have been brought in during a SP install since it is only available in Vista and above.

Hope that helps!
0
 
LVL 1

Expert Comment

by:IWillHelp
ID: 35085133
DEP (Data Execution Prevention) is an automatically enabled security feature that can assist in preventing many virus and other attacks within the server/computer.  When some viruses or other programs attempt to execute commands from within the RAM that is reserved for Windows processes, DEP will automatically close the program and error out on the screen with DEP Stop Error, or simular.

The #1 way that DEP is halted is if it is manually stopped or turned off using the BCDEdit command.  So the likelyhood of it being not enabled is near null.
0
 

Author Comment

by:mmoya
ID: 35085761
Got it...so what will be the actual command that I have to run? What should be the value I should use for the variable ID?

bcdedit /set <ID> pae ForceEnable
0
 
LVL 1

Accepted Solution

by:
IWillHelp earned 500 total points
ID: 35086720
Since you stated you are running Server 2008, you shouldn't have to enter any variable ID at all.  So the command WHEN RUN WITH ADMINISTRATOR RIGHTS should be "bcdedit/set PAE ForceEnable and then reboot.

And just to make clear, you run this by selecting Start - All Programs - Accessories - (right click on) Command Prompt - Run As... (Administrator)

Sorry for any confusion.
0

Featured Post

Integrate social media with email signatures

Is your company active on social media? Do you also use email signatures? Including social media icons in your email signature is a great way to get fans for free. Let all your email users know you’re on social media quickly and easily, in a single click.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

863 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

18 Experts available now in Live!

Get 1:1 Help Now