Post reply

Calculate the values for MAX Memory for SQL Server

  • December 20, 2011 at 2:13 pm

    #248419

    Comments posted to this topic are about the item Calculate the values for MAX Memory for SQL Server

    Rudy

  • February 9, 2012 at 9:26 am

    #1445152

    "Reserve 1 Gigabyte (GB) of RAM for the Operating System (OS)"

    Are you sure? Shouldn't it be 2GB?

  • February 10, 2012 at 6:57 am

    #1445530

    Yes this is correct as per the authors of the book. Also, there is other memory reserved it not just 1GB of RAM.

    Rudy

  • April 30, 2012 at 7:28 pm

    #1481568

    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)?

  • June 26, 2012 at 2:31 pm

    #1505843

    Change these two lines in your script to make it 2012 compatible -

    -- Read physical memory on server

    SET @TotalMEMORYinBytes = (select physical_memory_kb from sys.dm_os_sys_info)

    -- Coverting value from bytes to megabytes

    SET @TotalMEMORYinMegaBytes = (@TotalMEMORYinBytes /(1024))

  • 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

  • June 27, 2012 at 6:40 am

    #1506094

    scweichel (6/26/2012)

    Change these two lines in your script to make it 2012 compatible -

    -- Read physical memory on server

    SET @TotalMEMORYinBytes = (select physical_memory_kb from sys.dm_os_sys_info)

    -- Coverting value from bytes to megabytes

    SET @TotalMEMORYinMegaBytes = (@TotalMEMORYinBytes /(1024))

    Thanks for the update and it seem to work just fine in 2012 now 🙂

    Rudy

  • April 2, 2013 at 9:21 am

    #1602857

    Thank you for the scripts. It was a great help for me.

  • May 11, 2016 at 7:25 am

    #1878221

    Thanks for the script.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply