• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

What is the RAM limit on SQL Server 2005 32-bit, when running on a 64-bit OS?

The title says it ...

This suggests it's 4GB ... but the arguments over /AWE lost me:
http://serverfault.com/questions/95794/how-much-memory-can-sql-server-2005-x86-use-when-installed-on-windows-server-2008

I can't find it on an MS site.

Thanks!
0
Daniel Wilson
Asked:
Daniel Wilson
3 Solutions
 
lwalcherCommented:
The memory limit for SQL Server 2005 32-bit is the Operating System maximum, according to Microsoft:
http://blogs.msdn.com/b/psssql/archive/2008/04/05/sql-server-2005-memory-limits-and-related-questions.aspx

So, for example, on Windows Server 2008 Standard 64-bit, the limit would be 32 GB:
http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx#physical_memory_limits_windows_server_2008
0
 
twolCommented:
0
 
Adam BrownSr Solutions ArchitectCommented:
AWE is a SQL server option that allows you to address memory based on server limitations rather than the SQL server's limitations. This is a function that is only available to Enterprise and Datacenter versions of Windows 2003/2008, from what I can tell. http://www.sql-server-performance.com/2006/awe-memory/ has an explanation of what AWE is and how to configure it. Basically, it allows you to bypass the limitations of the x86 version of SQL. But the link you give is accurate about memory addressing by default in SQL x86. You can't address more than 4GB of memory in a 32-bit version of SQL without enabled AWE.
0
 
Daniel WilsonAuthor Commented:
Thank you all!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now