CODEWITHSUNDEEP
sql-server-2005memory-management
Anand Rastogi
Anand Rastogi

Reputation: 75

sql server 2005 32 bit on win 2003 64 bit using only 2 gb

We have sql 2005 32 bit running on win 2003 64 bit box containing 5 gb RAM. Is there a way that sql starts using more than 2 gb? some switch or some setting in sql server?

When I go to my sql server properties and try to increase the max server memory to > 2GB, it reverts back to old 2 GB.

Thanks,
Anand

Correction - Guys: I never noticed that the value mentioned in SQL Server config is in MB. Really very stupid of me - but when you assume things, you turn blind to even the most obvious things. I was assuming the value mentioned over there is in bytes - saw the config screen about 10 times and never really noticed it.

Upvotes: 2

Views: 1705

Answers (2)

gbn
gbn

Reputation: 432261

See Slava Oks article: Enabling AWE settings for SQL Server 32 bit edition in WOW. It can be done.

And your licensing team is talking rubbish about 32/64 bit license issues. See the licensing FAQ. You can mix and match x86/x64 licenses for both Processor and CAL. Unless you've shot yourself in the foot by using Workgroup edition where you can only go to 3Gb anyway. So AWE won't work anyway...

Upvotes: 3

Blorgbeard
Blorgbeard

Reputation: 103467

Have you checked the 'Use AWE to allocate memory' checkbox?

See Enabling AWE Memory for SQL Server on MSDN.

Upvotes: 0

Related Questions