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.

migrated from stackoverflow.com 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


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.

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