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: Thursday, April 17, 2014 6:48 AM
Points: 2,507, Visits: 3,645
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:28 PM
Points: 351, Visits: 1,657
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: Thursday, April 17, 2014 6:48 AM
Points: 2,507, Visits: 3,645
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 5:33 PM
Points: 743, Visits: 1,067
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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 04, 2014 5:41 AM
Points: 24, Visits: 260
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