We are running SQL Server 2000, SP3 Standard Edition on Windows Server 2000 SP4 with 4 gig of memory and a 4 gig swap file. My current settings in EM on the Memory Tab are Dynamically configured SQL Server Memory with a minimum of 0MB and a maximum of 3712MB. Sql Server is the only application (single instance) running on this box. Task Manager shows only 1700MB used by the SQL Server process. Based upon this thread should I

1-Lower the maximum memory to 2048MB?

2-Use the fixed memory option set to 2048MB?

3-Leave it alone?

Thank you for your recommendation.