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

Memory Grant - Not clear Expand / Collapse
Author
Message
Posted Sunday, February 23, 2014 2:36 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 10:33 AM
Points: 1,283, Visits: 2,959
In my attached execution plan when i hover over the Update statement it shows Memory grant as 22 gb and if i scroll all the way to right the Actual data size on left outer join on table2 and table 12 is 43 gb, i am not clear how estimated data size of operators can be more than actual Memory grant?


  Post Attachments 
MyExecPlan.sqlplan (6 views, 684.94 KB)
Post #1544312
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse