0

Saw this warning from query in plan cache

<Warnings>
     <MemoryGrantWarning GrantWarningKind="Excessive Grant" RequestedMemory="2751552" GrantedMemory="2751552" MaxUsedMemory="768" />
</Warnings>

Does RequestedMemory represent bytes or kilobytes?

How do you troubleshoot what caused this warning?

user2368632
  • 1,133
  • 1
  • 15
  • 33

1 Answers1

1

This is usually resultant (though I believe other things can also cause it) from Cardinality Estimate issues. You should look at the Actual Execution Plan and see if you have any mis-estimates by comparing the Estimated Number of Rows total to the Actual Number of Rows. If you update your question with the Execution Plan (you can upload it to Paste The Plan and link it to your question) then we can give you better direction on the source of your excessive memory grant issue.

J.D.
  • 40,776
  • 12
  • 62
  • 141