Question : Why is this simple query granted so much memory? — Demo table CREATE TABLE dbo.Test ( TID integer […]

Question : Saw this warning from query in plan cache <Warnings> <MemoryGrantWarning GrantWarningKind=”Excessive Grant” RequestedMemory=”2751552″ GrantedMemory=”2751552″ MaxUsedMemory=”768″ /> </Warnings> Does […]

Question : I have one query with multiple execution plans, the memory granted to one plan is huge comparing to […]

  • 1
  • 2