• That is correct, I guess I should have stated that if you want to have 7 GB, after SQL Server has acquired at least 7 GB for the buffer pool then it won't release below 7 GB of memory, but it seemed wordy 😀

    But you are right it was misleading my bad.



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]