I recently had a problem with one of my sql servers and it brought up a question. I had a very underpowered VM running replication. It was the subscriber and transactions weren’t replicating. The page life expectancy was 9000. I increased the memory on the VM form 4G to 32G. My page life expectancy fell to around 300 and my transactions started replicating. All was well.
My question was, even though it seemed to be a memory pressure issue, my SQL Diagnostic Manager SQL Used memory counter says SQL is only using 584M out of the 32 G. Shouldn’t this show that it is using most of the 32G?