Post reply

IF Time out in the application what all this to check at sql server level and at database

  • January 6, 2012 at 3:26 am

    #262570

    Hi All,

    Can you please share your knowledge if IF Time out Error comes in the application what all this to check at sql server level and at database.

    Regards,

    Sachin

  • January 6, 2012 at 5:58 am

    #1429573

    Hi

    Use sql profiler.

    Track all "statement completed" events having a high duration and then tune the bad query.

  • January 6, 2012 at 6:26 am

    #1429586

    timeout error comes at any specific time? or it comes certain event like report extraction or any other. ?

    if so try to figure our what exactly the requets are getting processed and analyze them.

  • January 8, 2012 at 10:11 pm

    #1430270

    Thanks for your reply.I am happy to hear the same as i was thinking.I do agree if timeout comes at any specific time then we can run profiler trace and if any report is taking more resouces then we can tune that too.

    If it's not so then what commands or stored procedure we can use please shed some light on that that will be helpful.

    Regards,

    Sachin

  • January 9, 2012 at 2:46 am

    #1430334

    There's no magic options or settings. Tune the procedure or query that's causing the timeout (or change the application's timeout setting)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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