Post reply

SQL Query Progress Bar

  • July 19, 2012 at 12:04 pm

    #259107

    Hey Guys,

    I am a novice sql coder, and I am experimenting with different queries. Some run quickly, where other have taken up to an hour.

    My question is how can one detect the total time length that a query will take to complete? Is there some type of progress bar that can be displayed?

    Any advice is more than welcome,

    Thanks very much,

    CJ

  • July 19, 2012 at 12:10 pm

    #1515076

    Nope. No progress bar available. Not really possible, either.

    You can get an estimated "cost" of a query, which can roughly translate to duration. But the "costs" are often way off, and only correspond to duration about as often as they don't.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • July 19, 2012 at 12:30 pm

    #1515093

    GSquared (7/19/2012)

    You can get an estimated "cost" of a query, which can roughly translate to duration. But the "costs" are often way off, and only correspond to duration about as often as they don't.

    And that's even before taking locks and other forms of waits into account

    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 3 posts - 1 through 2 (of 2 total)

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