question

Gehima2016 avatar image
Gehima2016 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?
timeoutsp
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
mdawini avatar image
mdawini answered
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..
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.