Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning SQL Server 2008 R2 Memory Hog RE: SQL Server 2008 R2 Memory Hog

  • March 10, 2014 at 9:56 am

    #1695615

    sqlbuddy123 (3/10/2014)

    And did you restart the SQL server after you changed the Max Memory to 4 GB ? This is to release excessive memory grabbed by SQL.

    Max server memory does not require a restart. It is effective immediately.

    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