Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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


Group: General Forum Members
Last Login: Friday, November 18, 2016 9:50 AM
Points: 1,525, Visits: 3,573
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