Post reply

Total of task cost of a query plan more than 100%

  • May 11, 2010 at 8:30 am

    #232494

    Did someone had that issue before?

    If so is it a reason why?

    It make debugging query plan more difficult if the total cost of tasks are over 100%...

    (Or did I miss a point somewhere?)

  • May 11, 2010 at 9:14 am

    #1165616

    It happens, as well as cases where the percentages add up to less than 100%. I forget the exact explaiantion that was given but, iirc it has to do with a mis-estimation of the number of times something will be executed.

    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

  • May 11, 2010 at 9:21 am

    #1165625

    Thank you!

    It makes a lot of sense with the current state of the query.

Viewing 3 posts - 1 through 2 (of 2 total)

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