MartynLawson
asked on
SQL Server only using 1.7GB of available RAM
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
Does anyone have any ideas how to configure SQL Server 2008 to utilise all RAM available
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Thanks very much
ASKER
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?