May 6, 2009 at 3:41 pm
I have one sql ent 2005 instance on my server. We often receive timeouts on resource intensive stored procs from both dbs hosted on that instance. Clearing proc cache or updating statistics on one of these dbs solve problem for couple days and after that time timeouts are back. Execution plans size for those SPs when timeouts occur are the same when they run without timeouts. Any info how can I diagnose problem will be very helpful.
May 6, 2009 at 4:06 pm
Is there any timeout interval specified in your code?
Check out for any kind of blocking or deadlocking on your server?
May 7, 2009 at 1:23 am
Timeout is thrown by our iis (timeout is set to 30 secs) but when I run those queries manually they run and run and after couple minutes i just cancel them.
If there is anything that blocks those queries it has to be at server level because we got timeouts from both dbs. It seems like one of resources is under pressure but after clearing proc cache or updating statistics they run normally again.Any thoughts?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply