I upgraded the SQL SErver from standard to Enterprise edition recently on a Windows 2000 server. Even though the system has 4GB memory, still only 1.7 GB is used by SQL server. I have set /3GB option and also awe is turned on. why it is not using more memory? The startup parametrs are set to use memory dynamically upto a max of 2.8 GB. But still no improvement. Could anyone help me with this?