Answer
SQL requests memory for sorting and hashing. Over-grants cause waits; under-grants cause spills to TempDB.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ