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

Blocking Causing Timeout Error Expand / Collapse
Author
Message
Posted Monday, January 27, 2014 12:41 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:48 AM
Points: 2,633, Visits: 3,977
Hi experts,

We are getting timeout error in our custom report server db. Timeout is causing the reports to fail.

In SQL error i found the timeout message along with some procedures. Can anyone please help how to resolve this.

The procedure name is different most of the times.

TIA
Post #1535167
Posted Monday, January 27, 2014 12:56 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:27 AM
Points: 401, Visits: 2,004
check for the query which is taking longer time to execute and do the performance tuning.
Or check for wait type of the query-

DO some performance tuning -if required do the update statistics or create new indexes.
Post #1535173
Posted Wednesday, January 29, 2014 9:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:48 AM
Points: 2,633, Visits: 3,977
Thanks for the reply..

I didnt find much tables used in query and the indexes in those tables seems proper.. The procedures are using table variables and temp tables mostly..
Post #1535968
Posted Wednesday, January 29, 2014 9:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 20, 2014 2:56 PM
Points: 835, Visits: 1,191
Have you checked the execution plan for those procs?
What are the wait type and last wait type you see for them?

Some more info will help better.
Post #1535978
Posted Friday, January 31, 2014 12:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 8, 2014 9:51 AM
Points: 25, Visits: 271
For the tables being queried, when was the last index maintenance performed?

Run a DBCC Showcontig on the tables in question.


Blog: http://sqlexchange.wordpress.com
Post #1536938
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse