A new hotfix is out for ConfigMgr 2007. It has to do with too many requests sent to the MP and a memory leak that may occur. More information can be found at the Micrsosoft configMgr blog
http://blogs.technet.com/configurationmgr/archive/2009/11/16/new-kb973499-a-memory-leak-occurs-when-many-content-location-requests-are-received-by-a-site-server-configmgr-2007-sp1.aspx