Blocking Causing Timeout Error

  • 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

  • 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.

  • 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..

  • 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.

  • 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