InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 22:50:14 GMT20http://www.sqlservercentral.com/Forums/Topic1224761-471-1.aspxThank you for the scripts. It was a great help for me.Tue, 02 Apr 2013 09:21:49 GMTnisha_ranahttp://www.sqlservercentral.com/Forums/Topic1224761-471-1.aspx[quote][b]scweichel (6/26/2012)[/b][hr]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 megabytesSET @TotalMEMORYinMegaBytes = (@TotalMEMORYinBytes /(1024))[/quote]Thanks for the update and it seem to work just fine in 2012 now :)Wed, 27 Jun 2012 06:40:11 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic1224761-471-1.aspx[quote][b]Tec_Chief (4/30/2012)[/b][hr]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)?[/quote]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,Wed, 27 Jun 2012 06:37:27 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic1224761-471-1.aspxChange 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 megabytesSET @TotalMEMORYinMegaBytes = (@TotalMEMORYinBytes /(1024))Tue, 26 Jun 2012 14:31:07 GMTscweichelhttp://www.sqlservercentral.com/Forums/Topic1224761-471-1.aspxGreat 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)?Mon, 30 Apr 2012 19:28:58 GMTTec_Chiefhttp://www.sqlservercentral.com/Forums/Topic1224761-471-1.aspxYes this is correct as per the authors of the book. Also, there is other memory reserved it not just 1GB of RAM.Fri, 10 Feb 2012 06:57:08 GMTRudy Panigashttp://www.sqlservercentral.com/Forums/Topic1224761-471-1.aspx"Reserve 1 Gigabyte (GB) of RAM for the Operating System (OS)"Are you sure? Shouldn't it be 2GB?Thu, 09 Feb 2012 09:26:16 GMTpkrudyszhttp://www.sqlservercentral.com/Forums/Topic1224761-471-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/max+memory+setting/86998/">Calculate the values for MAX Memory for SQL Server </A>[/B]Tue, 20 Dec 2011 14:13:47 GMTRudy Panigas