December 20, 2011 at 2:13 pm
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
"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
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
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
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
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
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
Thank you for the scripts. It was a great help for me.
May 11, 2016 at 7:25 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy