Same happened to me many times on extremely dynamic tables.
I cannot afford manual recovery.
I have key sprocs on sp_recompile every 1/2 hour or so.
My take on it that due to rapid/great number of inserts the execution plan become obsolete.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
BI Workshop NYC SSAS, SSIS, SSRS - April 21-24: http://www.sqlusa.com/