Memory question

Hello.

I have just intstalled 32-bit 2005 Standard Edition on a W2003 SP1 Server.

Am I right in assuming that this version will use as much memory as it can grab from the server up to a limit of 4Gb without me having to alter any settings in SQLServer or Windows?

Thanks

What's the w2003 version? If it is x86 OS, the max vas sql can use is 2GB according to default sql configration. If it is x64 OS, the max memory of sql is up to 4GB (assume the physical memory is enough)|||

apologies, it is 32-bit x86.

The physical memory in the server is 4Gb, can I make SQL use more of the available memory than 2Gb?

|||Yes, you can try to use /3GB or AWE. The actually memory usage will be increased to 2.6-2.7GB in 4G physical memory system.|||

ah-ha, I remember reading somthing about 3GB and AWE a long time ago.

The /3Gb thing increase the memory for any application but AWE increses it for SQL only, am I right?

oh, and Thanks

|||All AWE-aware applicaiton can benefit by AWE configration.|||

Hi,

You can check the article at http://www.kodyaz.com/articles/article.aspx?articleid=41 for sp_configure 'awe enabled' usage and editing boot.ini file for /3GB switch.

Eralper