SQL Server using 2 GB Ram out of 12 GB

Question

SQL Server using 2 GB Ram out of 12 GB

dgoyal2310

Valued Member

Points: 53
More actions
April 14, 2010 at 7:09 am

#217868

The server has following configuration
-- Windows 2008 Server 32 bits
-- SQL 2008 SP1 plus update patch 32 bits
-- 12 GB Physical RAM
-- 12 GB database
-- AWE and lock pages enabled
-- SQL Max Memory 8 GB
-- SQL Min Memory 1 GB
-- Task Manager shows only 3.5 GB Physical Memory
-- dm_resource_governor_resource_pools shows Max_memory 1.47 GB
-- dm_resource_governor_resource_pools shows used memory 910 MB
SQL server seems using less memory and from Windows task manager the maximum memory taking by sqlservr.exe is 80 MB only. It is maximum memory taken by the process as seen in task manager's process list.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Tom257 SSChampion Points: 11543 More actions · Answer 1

You may need to enable memory over 4Gb in Windows

Look up physical address extension (PAE) and Data Execution Prevention (DEP) - I know I had a 2003 server machine that had PAE disabled and showed only 3.5 Gb in task manager, when it was enabled (by changing the DEP setting in bios) - it showed the full 8Gb that was installed.

dgoyal2310 Valued Member Points: 53 More actions · Answer 2

In Windows 2008 Server, we dont have boot.ini, so can you please guide us how we enable PAE in Windows 2008 Server

HowardW One Orange Chip Points: 29109 More actions · Answer 3

See the below:

http://msdn.microsoft.com/en-us/library/aa366796(v=VS.85).aspx

Tom257 SSChampion Points: 11543 More actions · Answer 4

On my Windows 2003 machine PAE was set up automatically after I changed the DEP setting in BIOS.

Not sure if this applies to windows 2008, http://msdn.microsoft.com/en-us/library/aa366796(VS.85).aspx but it may help.