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!
Crucio666Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Upgrade your Question Security!

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

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.