Link to home
Start Free TrialLog in
Avatar of BrookK
BrookK

asked on

Stored procedures recomplilation

Hello All,

I did major deployment over the weekend. Since then there are two sprocs which are giving timeout/hour glass in the application. The sprocs if I recompile they seem to work fine. But then again after couple of hours they create issues.

Can anyone tell me why recompilation solves the problem for time being? What could be the real fix for these sprocs?

Please advice?

Thanks,
-B
ASKER CERTIFIED SOLUTION
Avatar of sventhan
sventhan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BrookK
BrookK

ASKER

Thank you so much that helped a lot.
Avatar of BrookK

ASKER

Helped