Cost in Execution Plan summing up more than 100

Question

Post reply

Cost in Execution Plan summing up more than 100

sqlnaive

SSCoach

Points: 17437
More actions
September 3, 2013 at 2:23 am

#276757

Hello All, In rare cases, I saw some strange behaviour in the execution plan. What I believe is that it distributes the cost among the sub processes taking 100% as a whole. But at times I see the total cost exceeding 100% (at this tme 101%). I checked some sites and they state is a bug. Not that it affects anything and then also help resolve issues but was just curious to know if anyone has any updates on this ?

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

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

John Mitchell-245523

SSC Guru

Points: 148809

September 3, 2013 at 2:31 am

#1646905

Could it be a rounding error?

John

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

It's a bug in Management studio

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

Neeraj Prasad Sharma Ten Centuries Points: 1315 More actions · Answer 3

please check this link its a bug

http://connect.microsoft.com/SQLServer/feedback/details/621330/sum-of-operator-costs-is-more-than-100-in-the-execution-plans

Neeraj Prasad Sharma
Sql Server Tutorials

sqlnaive SSCoach Points: 17437 More actions · Answer 4

Neeraj Prasad Sharma (9/3/2013)
please check this link its a bug
http://connect.microsoft.com/SQLServer/feedback/details/621330/sum-of-operator-costs-is-more-than-100-in-the-execution-plans

Neeraj, I already checked that link but since it was old (probably in 2009 or 2010, so wanted to know if anyone has any update on that. Gail just confirmed that.