locked
Timeout issue RRS feed

  • Question

  • Hi,

    We had timeout for one application connnected to sql server 2005. How to find out what cauase that timeout? where to check?

    thanks

    Wednesday, March 6, 2013 4:09 PM

Answers

    • Proposed as answer by Fanny Liu Monday, March 11, 2013 9:51 AM
    • Marked as answer by Fanny Liu Thursday, March 14, 2013 7:53 AM
    Wednesday, March 6, 2013 4:23 PM
  • Hi,

    We had timeout for one application connnected to sql server 2005. How to find out what cauase that timeout? where to check?

    thanks

    Run a Profiler to figure out the timeout issue, if the issue is reproducible.


    HTH, \\K [Kindly mark the reply as answer if it helps - Support SQLServer Family :-)]

    • Proposed as answer by Fanny Liu Monday, March 11, 2013 9:51 AM
    • Marked as answer by Fanny Liu Thursday, March 14, 2013 7:53 AM
    Wednesday, March 6, 2013 8:26 PM

All replies

  • I'd start by looking for excessive blocking in the database.

    Mike Hotek mhotek@mssqlserver.com

    Wednesday, March 6, 2013 4:19 PM
    • Proposed as answer by Fanny Liu Monday, March 11, 2013 9:51 AM
    • Marked as answer by Fanny Liu Thursday, March 14, 2013 7:53 AM
    Wednesday, March 6, 2013 4:23 PM
  • Hi,

    We had timeout for one application connnected to sql server 2005. How to find out what cauase that timeout? where to check?

    thanks

    Run a Profiler to figure out the timeout issue, if the issue is reproducible.


    HTH, \\K [Kindly mark the reply as answer if it helps - Support SQLServer Family :-)]

    • Proposed as answer by Fanny Liu Monday, March 11, 2013 9:51 AM
    • Marked as answer by Fanny Liu Thursday, March 14, 2013 7:53 AM
    Wednesday, March 6, 2013 8:26 PM