Lonny Niederstadt answers the call from someone who needs the combination of Perfmon and DMV data:
When is a maximum not really the maximum?
When it’s a maximum for an explicitly or implicitly modified default.
Whether “the definitive documentation” says so or not.Yesterday on Twitter #sqlhelp this question came up.
*****
#sqlhelp Anyone have DEFINITIVE documentation on what the MemoryManager.Maximum Workspace Memory counter indicates (grant-able mem right?)— Michael K. Campbell (@AngryPets) October 17, 2017
*****
Aha! I thought to myself. For this I am purposed! To show how Perfmon and DMV data tie out!
Read on for the simple form of the answer, followed by the complication which makes life interesting.