Solved

SQL Server only using 1.7GB of available RAM

Posted on 2011-03-01
4
827 Views
Last Modified: 2012-05-11
We have a Windows 2008 32 bit Enterprise Edition server that has 8GB of RAM installed. The server is running SQL Server 2008 32 bit Enterprise Edition, but SQL is using no more than 1.7GB of RAM. We have using the AWE command is SQL Server but the SQL only used 60MB once this command had been run. We would like to configure SQL to use all of the RAM available for use on the server.

Does anyone have any ideas how to configure SQL Server 2008 to utilise all RAM available
0
Comment
Question by:MartynLawson
  • 2
4 Comments
 
LVL 5

Accepted Solution

by:
sindhuxyz earned 250 total points
ID: 35006259
0
 
LVL 1

Author Comment

by:MartynLawson
ID: 35007110
I've looked through the articles that you have sent through and we have already performed the tasks that you have suggested.

When the server was first built it was only registering 3.34GB in Task Manager, so we ran bcdedit /set PAE forceenable and all the RAM became visible, but SQL was only showing as using 1.7GB. We then tried to configure AWE, but once this had been configured it showed in Task Manager that it was only accessing 60MB. I have been led to believe that this is not correct, but at the some time the SQL process is maxing out the CPU when performing any transactions.

Do you have any other suggestions for correcting the fault that we are experiencing?
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 250 total points
ID: 35030509
After you enable AWE you should check in Control Panel under Security  - Local Policy and make sure  "Lock Pages in Memory" is enabled for the account starting SQL Server Service. Please see details at:  http://msdn.microsoft.com/en-us/library/ms179301.aspx
0
 
LVL 1

Author Closing Comment

by:MartynLawson
ID: 35084383
These solutions did help towards the resolution of the problem. The utilisation in task manager does not appear to be a true representation of the memory allocated to the SQL server. We maanged to find the true information when looking through perfmon

Thanks very much
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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 the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

679 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