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.

  • 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

| 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.

| 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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