January 27, 2014 at 12:41 pm
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
January 27, 2014 at 12:56 pm
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.
January 29, 2014 at 9:14 am
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..
January 29, 2014 at 9:30 am
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.
January 31, 2014 at 12:45 pm
For the tables being queried, when was the last index maintenance performed?
Run a DBCC Showcontig on the tables in question.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply