{"version":"1.0","provider_name":"Joe Sack","provider_url":"https:\/\/www.sqlskills.com\/blogs\/joe","title":"Memory Grant Execution Plan Statistics - Joe Sack","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"nc9lrQBoog\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/joe\/memory-grant-execution-plan-statistics\/\">Memory Grant Execution Plan Statistics<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.sqlskills.com\/blogs\/joe\/memory-grant-execution-plan-statistics\/embed\/#?secret=nc9lrQBoog\" width=\"600\" height=\"338\" title=\"&#8220;Memory Grant Execution Plan Statistics&#8221; &#8212; Joe Sack\" data-secret=\"nc9lrQBoog\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/www.sqlskills.com\/blogs\/joe\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"SQL Server 2008 execution plans include an optional MemoryGrant attribute in the QueryPlan element \u2013 but SQL Server 2012 significantly expands on memory grant related statistics with the new MemoryGrantInfo element and associated attributes. Here is an example of MemoryGrantInfo from an actual SQL Server 2012 execution plan: &lt;MemoryGrantInfo SerialRequiredMemory=&quot;5632&quot; SerialDesiredMemory=&quot;11016&quot; RequiredMemory=&quot;47368&quot; DesiredMemory=&quot;52808&quot; RequestedMemory=&quot;52808&quot; GrantWaitTime=&quot;0&quot; [&hellip;]","thumbnail_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-content\/uploads\/windows-live-writer\/memorygrantinfo\/259b5db2\/snaghtmla4ae6cb_thumb.png"}