[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 489
  • 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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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