Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rudy Panigas Calculate the values for MAX Memory for SQL Server RE: Calculate the values for MAX Memory for SQL Server

  • June 27, 2012 at 6:37 am

    #1506092

    Tec_Chief (4/30/2012)

    Great Script.. Thank You. Can you add direction on how to take your script results and have it use the MAX MEM (SQLMaxMemoryMegaByte) results to automatically change/update the SQL settings (i.e. sp_configure max server memory)?

    Hello,

    Not sure why you want to automatically change the memory setting. Since you don't need to do this often, I would recommend just executing the script and then copy/paste the results to make you memory change.

    Thanks,

    Rudy