We are having intermittent problems with timeouts which it would seem are caused by the execution time of a particular SP.

Can anyone suggest a method to force an SP to pause/sleep/wait during processing in order that we can confirm this is the case?