Hello Paul,

FYI:

I was using sql server 7.0 standard edition RAM 2.0 GB. Memory setting Dynamic. Now we have upgraded the server to 4.0 GB.

After the memory upgrade the problem starts; server runs for a few days and suddenly went down. After the investigation we found that sql server eats up memory and there will be no memory left for the OS. After that we have fixed the memory settings to use fixed 2.0 GB and problem solved.

Hence I conclude that here one of the culprit COULD be Memory Leak.

Hope this will satisfy you.