I have a server running Windows 2003 Enterprise (x86) and SQL Server 2005 Enterprise SP.
The sqlserver process currently consumes aorund 1.6GB of memory although there is around 12GB in the sever (the OS only see's 4GB due to 32 bit limitation). To use all this memory will I need to upgrade to a 64bit OS and 64bit SQL Server enterprise?
I have aslo read about using AWE but would like do it do it without that if possible.
asked Mar 07, 2010 at 03:00 PM in Default
answered Mar 07, 2010 at 06:30 PM
To let SQL Server use the majority of that 12GB, you'll need to either use 64-bit or AWE.
But it seems odd that it's stopping at 1.6GB, when 32-bit systems support much more than that. Could it be that your databases are sufficiently small so that 1.6GB is all you need?
answered Mar 07, 2010 at 10:26 PM