Execution Plans

• NickDBA

  Hall of Fame

  Points: 3792

  More actions

  October 21, 2010 at 8:24 am

  #242017

  Hi experts

  A general question regarding the Memory Grants value shown in the properties of an operator in a SQL Server execution plan. Basically, what is this value a measure of / telling me?

  Thanks in advance

  Nick

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  October 22, 2010 at 5:41 am

  #1240832

  It's describing the amount of memory used to store temporary row data for sorts & other operations. Here's a great blog entry from MS on it.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning