Jon Gurgul's Blog

Tag: Max Server Memory

  • SQL Server Memory: Max Server Memory or Task Manager is wrong

    —

    by

    Jon Gurgul
    in

    Issue 1: max server memory <> max server memory Okay so you have run sp_configure and checked SQL and it has stolen more memory than you told it to. Aghh! sp_configure ‘show advanced options’, 1; GO RECONFIGURE; GO sp_configure ‘max server memory’, 4096; GO RECONFIGURE; GO http://msdn.microsoft.com/en-us/library/ms178067.aspx Why do you fight me SQL Server? Use…