asked
SP timeout
We have this stored procedure that have been running well. But it just started to timeout when users tries to call it. Any clue as what might be the problem?
Give us more details about the proc. How big is the resultset. Are your statistics up to date... indexes .. any table or index scans... could be so many issues here. But try it in your dev or UAT environments and look at the execution plans.... parameter sniffing... etc etc..
19 People are following this question.
