• coolchaitu (6/16/2016)


    max server memory just controls the buffer pool, not CLR, full text,multiple other processes that run outside of the Buffer Pool memory

    Those are small amounts of memory usually, few hundred MB, couple GB at most unless you're doing some really strange CLR, that's why max server memory settings are usually suggested conservative and increase if there's free memory still.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass