Our SMS 2.0 site ran fine for 4 months, then we started experiencing exactly the same problem.....memory usage goes up until we run out of virtual memory. With Microsoft's help, we tracked the problem down to the processing of client hardware inventory MIF's. The problem still exists and there is still an open ticket with Microsoft. To stop the problem for now, they had us rename the dll that handles hardware inventory MIF's. The file is in the SMS/BIN/I386 folder on the site server and is called invproc.dll. They had us rename it to oldinvproc.dll for now to stop the processing of these MIF's. SMS now runs fine with the downside that the hardware inventory of our clients is not getting updated at the moment. The client software inventory is still functional.

I submitted a question regarding lock ups and memory errors but your advice is great, so thank you.  Secondly, it seems as though we have the same problem here at my company as you describe.  I will put in a call to Microsoft as well so they will look into this further.  

Thanks again
GScala

It could be MDAC.  I don't know what SP you are using, but there is a bug with MDAC 2.0 sp1 that causes a memory leak.  If you are using this, try upgrading to sp2.

Actually, this problem has not repeated itself since we upgraded SMS to SP1 and SQL 7 to SP1.  We are now back to processing hardware inventory MIFs as normal.

Tom Thaden
thadents@usano.ksc.nasa.gov

Hi all again, I ment to say MDAC 2.1 SP1 has the memory leak, my other response stated MDAC 2.0 incorrectly.