0

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.

1 Answer 1

3

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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