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 […]

  • 1
  • 2