Timeline for Difference between 'GrantedMemory' and 'MaxQueryMemory' attributes in Showplan XML
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 5, 2018 at 14:16 | comment | added | Joe Obbish | @SqlWorldWide There are some trace flags that allow granted memory to change during an execution for some batch mode operators. I don't know how that's reported in the XML. | |
| Feb 5, 2018 at 13:40 | comment | added | SqlWorldWide | Thank you. I did some reading about adaptive query processing in 2017. Also read this article. blogs.msdn.microsoft.com/sqlqueryprocessing/2010/02/16/… server-memory-grant/ Up to 2016 when a query plan is chosen and memory is allocated (based on RequestedMemory and GrantedMemory) can Granted memory change during execution? Will I ever see a higher number in 'GrantedMemory' compare to 'RequestedMemory'? Is that what 'MaxQueryMemory' is telling me--that if you need more on the fly that is your limit? If you prefer I can spin up a new question. | |
| Feb 5, 2018 at 13:38 | vote | accept | SqlWorldWide | ||
| Feb 5, 2018 at 4:29 | history | answered | Joe Obbish | CC BY-SA 3.0 |