We have SQL Server 2005 Standard Edition running Windows 2003 Enterprise Edition (both 32 bits) with 4 processor and 32GB RAM.
In SQL Server properties it shows all 32GB memory. But when I checked in error log it shows 4 processor and 4096MB memory detected. AWE is enbaped. Max server memory is setup 24GB.
I have doubt SQL can use 24GB as in error log it shows only 4098GB memory detected. I want to sql server access all allocated memory.
There's some debate about that, you can Google it and read about it. But on 32 bit systems it's the only way for AWE to function properly, and therefore the only way to address > 4GB RAM. The sooner you can upgrade to a 64 bit OS, the better.
SQL Server 2005 Standated Edition Memory Limit
Posted - 10/29/2012 : 16:14:28
