Stored procedure running for long period and time out RRS feed

  • Question

  • Hi

    We have an sp which do some calcualtion. it was running fine till yesterday morning and suddenly it start consuming more than 10 minutes, this happened in our production database. to identify the issue we have taken a production backup and run the same sp and it took just 47 secs to finish running, while we ran in production the user base was lesser than usual .

    Today morning we have taken a fresh back of production database and swapped the database and the sps start running at usual time 47 sec in live .

    I wonder if there is any data or page corruption in that database. is there a way to identify this ? 

    Thursday, August 1, 2019 11:16 AM

All replies