Have two stored procedure that have been running fine up until two days ago. One used to take several seconds to run but now takes more than 20 minute and is causing the batch job that runs it to time out. The other runs without doing anything. No changes to the code or application have been made. Any recommendations?