Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am running SQL Server 2005 Standard x64 on Windows server 2003 R2 x64. I have 32GB of total server RAM. I am unable to make SQL Server use more than 3 GB of memory, even I set min and max server options as follows:

sp_configure 'show advanced options', 1

sp_configure 'min server memory', 1024

sp_configure 'max server memory', 24576

What could be a problem?


There was SQL Server 2005 32bit installed. See my answer.

share|improve this question

migrated from Aug 8 '11 at 19:59

This question came from our site for professional and enthusiast programmers.

How big is your dataset? SQL will only use what it needs to so if your dataset is less than 3GB then it's wont user more than that – Zypher Aug 8 '11 at 20:59

Actually I did recognize that there was 32 bit version of SQL server installed. After re-installation the problem was solved.

Thank you very much for your efforts.

Cheers Darius

share|improve this answer

You need to add a directive to the Boot.ini on your root drive.

under the [operating systems] header you should add /3gb switch at the end of the OS entry.

share|improve this answer
Doesn't apply to 64-bit operating systems – Mark Henderson Aug 8 '11 at 20:58
You don't need this on 64bit systems, it's a workaround for limitations on 32bit systems – Zypher Aug 8 '11 at 20:58

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.