Pulled up the resource monitor while running a large Staging => Presentation layer INSERT. When I sort by Commit (KB) descending, I can see about 2-3G worth of memory accounted for. When I look at the "total in use" metric, it shows 33 of my 36G being used.
Where is it all going?
I'm looking for a link to an article as I'm sure I'm not the first confounded by this.
PS --> after the process finished moving 36MM rows, the memory #'s remain unchanged. This is NOT a production box, and I'm the only one using it right now.