I have a complex stored proc that was taking 35-40 secs to execute. It is now taking 3min 30+secs to execute. This stored proc still runs in 35 secs on my test sql server box. Nothing has changed on the production configuration. The indexes on the production server are updated every Sunday. Any clues???