• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 548
  • Last Modified:

SQL SERVER NOT UTILIZING ALL RAM

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!
0
Crucio666
Asked:
Crucio666
  • 3
  • 2
  • 2
  • +2
4 Solutions
 
bradleys40Commented:
have you got hot memory?
/3GB is ok unless you have added hot memory see article http://support.microsoft.com/kb/822842/en-us
0
 
bradleys40Commented:
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
0
 
Crucio666Author 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?
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
SQL_SERVER_DBACommented:
32 can only use 4g ram
0
 
chikenheadCommented:
The /3GB switch is incorrect.  for SQL you just need /PAE.  
0
 
chikenheadCommented:
Yes SQL standard 32 bit will not recognize more than 4GB for that you need SQL 64bit
0
 
chikenheadCommented:
and yes 64 bit standard will do up to 64 BG of RAM
0
 
Crucio666Author 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?
0
 
David ToddSenior DBACommented:
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
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now