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: Wednesday, October 5, 2016 2:34 PM
Points: 1,517, Visits: 3,557
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