Configure min and max memory settings

  • I am running SQL Server Standard 2005/SP2 on a Win2003 R2/SP2. This is a VM environment. Nothing else runs on the server besides SQL Server.

    I was receiving both sort and hash warnings in my default trace. The memory available to the server was bumped up from 3 to 4 GBs.

    Currently and previously my memory settings are min=0 and max= 2147483647. 'Use AWE to allocate memory" is unchecked.

    Can someone provide some guidance on how I can make more memory available to SQL Server. I am unsure if I need to check AWE or if I can just increase max to 3 GBs.

    Thanks for any guidance...

  • This is all 32 bit....

  • If only 4GB physical RAM available all you can do is add the /3GB switch to the boot.ini file. No need to change max server memory setting.

    If this is standard edition of the OS you are limited to 4GB max in the server. To go higher you would need enterprise edition of the OS, and that is a reinstall of the OS, not an upgrade.

    ---------------------------------------------------------------------

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply