***** Update 2021 December 7 *****
In the DIY section of this post I added an explanation about the up-to-five second delay between creation of the column store object pool memory broker clerk, and the update to [Target pages]. I also added some modified code with built in WAITFOR '00:00:06' between each operation and checking the memory counters :-) That always gives the desired results... but wow waiting ~36 seconds for it to complete seems like it takes forever.
Happy holidays, y'all.
***** End Update December 7 *****
I use perfmon a lot for SQL Server stuff :-)
Have you ever looked at how the Microsoft Docs describe [\SQLServer:Buffer Manager\Target pages]?
There's not much there. As of 2021 December 6:
|Target pages||Ideal number of pages in the buffer pool.|
So much so that I wrote 3 posts (so far) about this issue.
The second post:
The third post: