Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execution plan whose components add up to 248% Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 8:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:51 AM
Points: 2,693, Visits: 4,755
I have attached an execution plan whose components are adding up to 248%

Though I was able to resolve the performance issue I had, I am just curious to know why this happened
Has anybody seen such occurrence before and does any know the reason?

The SQL Server version is 2008 and I get the below result when I select @@VERSION
Microsoft SQL Server 2008 (SP3) - 10.0.5770.0 (X64)   Dec 29 2011 17:33:21   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 



Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/


  Post Attachments 
ExecutionPlan.sqlplan (13 views, 42.14 KB)
Post #1467198
Posted Wednesday, June 26, 2013 3:58 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:37 AM
Points: 997, Visits: 3,089
This happens in concatenation when the path is not executed due to the request being satisfied. The path is not executed (as seen by 0 actual rows after the clustered index scan on clo_AccountAccountDynamicFieldPK_CS) and therefore the actual cost is 0% however the estimated cost is still displayed.

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




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1467541
Posted Wednesday, June 26, 2013 5:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:51 AM
Points: 2,693, Visits: 4,755
Thanks for the link Sean. That explains it really well.
I was surprised when I saw the plan initially but now I am clear.



Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1467567
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse