If an SQL SERVER process (running via a stored procedure) becomes very
slow (usually takes 60 mins to run, now takes 180 mins to run) what
steps would you take to diagnose why there has been an increase in run
time and what could potentially be the cause?
Please kindly let me know. thanks a lot!