Post reply

query fail after 727855 reads and 30005 duration

  • November 27, 2015 at 8:34 am

    #399393

    hi all

    i have SQL:BatchCompleted with error 2 - Abort

    the query is generated from query builder

    and executed from web application

    and it is fails

    when perform tracing

    it give me that

    727855 Reads

    30005 Duration

    2 - Abort Error code

    can any one tel me how to discover what coz this fail

  • November 27, 2015 at 1:05 pm

    #1842681

    check to see if that querybuilder has a timeout. the 30005 duration looks a bit too suspiciously like a timeout. Just a guess tho!

  • November 27, 2015 at 3:55 pm

    #1842692

    Thanks patrickmcginnis59 10839

    can you tel me how to trace "SQL:BatchCompleted"

    and find the error details

    coz i only got error code without details

  • November 28, 2015 at 12:37 pm

    #1842725

    amrmnabil74 (11/27/2015)

    Thanks patrickmcginnis59 10839

    can you tel me how to trace "SQL:BatchCompleted"

    and find the error details

    coz i only got error code without details

    Yes... transfer the code to SSMS, give it the same parameters that the managed code was using, and troubleshoot from there.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • November 28, 2015 at 2:10 pm

    #1842729

    Yeah, looks very much like the client tool aborted the query because it took too long (timeout). Nothing wrong with the query, it's just taking too long. See if you can tune it, reduce the time it takes.

    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