Solved

SQL Server only using 1.7GB of available RAM

Posted on 2011-03-01
4
819 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 39

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

929 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

15 Experts available now in Live!

Get 1:1 Help Now