I manually ran query in SSMS and captured actual execution plan of the query by enabling its icon in SSMS. I am not getting "Memory Grant" when I keep my mouse on SELECT OPERATOR. I didn't get in properties window as well. I checked the XML data of plan as well and I am getting below Information which is not useful:

<MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="629094" EstimatedPagesCached="78636" EstimatedAvailableDegreeOfParallelism="2" MaxCompileMemory="3836688" />

I tried mulitple versions of SSMS but no luck.

Anyone else has faced this wierd issue? Any help would be appreciated.


Your query is probably very simple and does not require any memory grant.

It is trivial to reproduce:

enter image description here

See Understanding SQL Server memory grants for more background.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.