Error 701 "There is insufficient system memory to run this query"

[sonname]

I am getting this kind of error in sql server, when this happens, I can't do anything anymore, I need to stop and restart the server. In the log Files, I'm seeing these warnings "WARNING: Failed to reserve contiguous memory of Size= 65536". If anyone has some insight into what might be wrong, I would appreciate any help. Sorry if this is a long post.

Here are some details about the system.

-SQL Server 2000 running on a cluster with 4 GB of RAM and 4 processors.
-Service pack 2 has been applied

here are some values in the sp_configure

name minimum maximum
awe enabled 0 1
max server memory (MB) 4 2147483647
max text repl size (B) 0 2147483647
max worker threads 32 32767
media retention 0 365
min memory per query (KB) 512 2147483647
min server memory (MB) 0 2147483647
network packet size (B) 512 65536

Thanks

 

[sujitkandi]

I am not very sure about this but Do you have enough hard disk space ?
I also faced same type of problem in past on subsequent investigation I found my hard disk was running low of space .

Regards
Sujit

 

[SQLSister]

Is it always failing on the same query or on differnt queries? also does it happen at a specific time or time interval or randomly as far as time is concerned? is there any relationship between the failure and the number of users logged in?

 

[SQLBill]

Is your TEMPDB set to allow expansion?

(In enterprise manager, expand your server, right click on TEMPDB and select properties. Select the Data Files tab and in the section for File Properties, check that Automatically Grow File is checked. And ensure that the growth size will be large enough for what you are doing.)

-SQLBill