• praneethydba (4/10/2014)


    and he reduced the memory CAP to 10 GB, and no issues till now....

    Why? Why would you want more than half of the memory on the server to go completely to waste? Why would you want to cripple SQL by limiting its memory that much?

    Sure, that's going to reduce the % memory used but it's counterproductive. Free memory is memory not being used, it's memory going to waste, it's a waste of money spent on that memory. By doing that you will have around 16GB memory doing absolutely nothing, may as well remove that 16GB from the server and throw it away as that's the equivalent of what's been done there.

    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