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 10:46 am

    #1695655

    GilaMonster (3/10/2014)

    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.

    Yeah, I know. This is true when going from lower value to higher value and not necessarily Vice Versa. That's why I mentioned

    This is to release excessive memory grabbed

    http://social.msdn.microsoft.com/Forums/en-US/7e245bab-b694-4db1-b148-bb31d8b20cea/sql-server-memory-setting-restart-required?forum=sqltools

    --

    SQLBuddy