Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
RECONFIGURE
GO

sp_configure 'min server memory', 1024
RECONFIGURE
go

sp_configure 'max server memory', 24576
RECONFIGURE
GO

What could be a problem?

Update

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

share|improve this question

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
add comment

2 Answers

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
add comment

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
add comment

Your Answer

 
discard

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.