We help IT Professionals succeed at work.

SQL SERVER NOT UTILIZING ALL RAM

Crucio666
Crucio666 asked
on
Medium Priority
558 Views
Last Modified: 2008-01-31
Hello Experts,

we have a Server 2003 Enterprise 32 bit server with 16gigs of ram.

we are using SQL 2005 SP2

SQL was setup with the permission for the service account to lock page memory, sql was also enabled with awe and bootini was modified with the /pae /3gb switch.

SQL is still only utilizing 4gig of ram. What else can we check to see what is the cause of this?!

Thanks so much!
Comment
Watch Question

have you got hot memory?
/3GB is ok unless you have added hot memory see article http://support.microsoft.com/kb/822842/en-us
here is another good site with the relevent stored procedure executes to alter the memory allocation
http://sqlserver-qa.net/blogs/perftune/archive/2007/12/28/3048.aspx

Author

Commented:
memory is recognized by windows fine, it's not hot memory.....

does it matter if i'm using 32bit enterprise server and standard 2005 sql?
32 can only use 4g ram
The /3GB switch is incorrect.  for SQL you just need /PAE.  
Yes SQL standard 32 bit will not recognize more than 4GB for that you need SQL 64bit
and yes 64 bit standard will do up to 64 BG of RAM

Author

Commented:
ok so in conclusion my SQL Standard Edition 2005 is not going to utilize more than 4gigs of ram because i'm not using a 64bit operating system?
Senior Database Administrator
CERTIFIED EXPERT
Commented:
Hi,

Today if you want to go beyond 4GB ram, then it makes sense to goto 64Bit OS, and for SQL the 64Bit version of the appropriate edition.

http://www.microsoft.com/sql/techinfo/whitepapers/advantages-64bit-environment.mspx

Cheers
  David

Explore More ContentExplore courses, solutions, and other research materials related to this topic.