By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

Stored procedure problem

P: 83

For some reason, every 2/3 days a stored procedure on my database will start to timeout during operation. The load is normal and the indexes have been recently ( a few days ago) rebuilt. To solve the timeout i drop and then recreate the stored procedure in question. This always fixes the problem and then 2/3 days later it reoccurs. I really don't understand why thei happens, do SPs become fragmented like indexes over time and suffer perfomance degradation.

Any help would be much appreciated.
Sep 28 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.