Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

timeouts on resource intensive queries on all dbs Expand / Collapse
Author
Message
Posted Wednesday, May 06, 2009 3:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 08, 2009 5:15 AM
Points: 2, Visits: 9
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.
Post #711644
Posted Wednesday, May 06, 2009 4:06 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
Is there any timeout interval specified in your code?

Check out for any kind of blocking or deadlocking on your server?

Post #711662
Posted Thursday, May 07, 2009 1:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 08, 2009 5:15 AM
Points: 2, Visits: 9
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?
Post #711810
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse