Hi, We have performance issue on one of our prod servers. it is Windows 2003 which has 8GB of RAM on it and running SQL server 2005. for SQL server 2005, the memory settings are : Minimum Server Memory: 128MB Maximum Server Memory: 4096 MB Minimum memory per query is set to 1024 KB. Checked the SQL server log and found the following errors: spid60 Error: 701, Severity: 17, State: 123 spid60 There is insufficient system memory to run this query. The actual problem here is that the OS is stating that it has only 200MB of free memory left. I have been trying to fix this problem from long time...please help ASAP. Please help! Thanks in advance.