Mystery of memory fraction in Showplan XML

If you examine Showplan XML, you may find an entry like  <MemoryFractions Input=”1″ Output=”1″ /> on some operators .  They are internal parameters used by query memory grant to save overall memory usage, and “fraction” means how much this operator is allowed to use from “total additional memory” (please see previous post for definition on additional memory)….

1