Solved

SQL Server only using 1.7GB of available RAM

Posted on 2011-03-01
4
833 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
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…

623 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