Post reply

how to capture timeout-ed queries using profiler?

  • August 13, 2008 at 9:10 am

    #125721

    I could not find anything by googling. Anyone have ideas?

    Thanks!

  • August 13, 2008 at 9:31 am

    #857523

    As far as I know, there is no such parameters used for timeout exclusively.

    May the following link help in configuring your profiler. Use search engine, type in timeout, you can find the right content.

    http://support.microsoft.com/kb/224587

  • August 13, 2008 at 9:33 am

    #857526

    Thank you! I will give it a try.

  • August 13, 2008 at 1:34 pm

    #857688

    As far as I know, there is no such parameters used for timeout exclusively.

    May the following link help in configuring your profiler. Use search engine, type in timeout, you can find the right content.

    http://support.microsoft.com/kb/224587

  • August 13, 2008 at 1:41 pm

    #857690

    Know what the database request timeout is, and then look for things coming from the offending application with durations exceeding this. The default timeout for ADO is 30 seconds. The duration won't exceed it by much - Timeout + time to roll back the transaction + up to another second.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply