Other than faking memory pressure to get sql to release memory, is there any other way to quickly release memory?
My issue is I do large imports every few nights. This spikes my memory, but once the import is complete, I no longer need immediate access to that table, so I can release the memory. However there's no way for sql server to do that apparently
other than having the os pressure it to release it by temporarily running another memory consuming process.
I know what you'll say, if the os doesn't need it, why release it? Because I have multiple virtual machines working with a set memory pool size. If I have one box taking up 16gb of my pool, the other machines will suffer, and that one machine
will have no idea that it needs to release the memory, even if it is not actively using it.
View Complete Post