Less than 1 week –
Less than 10 hrs/week –
We have a sproc that usually takes 2 minutes to run. Every so often and more frequently recently it either takes a long time (20 minutes plus) or it hangs completely.
Our only solution is to back up and restore the database. And on one occasion we had to delete the database, create a new database and then restore into the new database. Once we have done either of the above the sproc, once again, only takes 2 minutes.