Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Calculate the values for MAX Memory for SQL Server Expand / Collapse
Author
Message
Posted Tuesday, December 20, 2011 2:13 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:14 PM
Points: 312, Visits: 1,106
Comments posted to this topic are about the item Calculate the values for MAX Memory for SQL Server


Post #1224761
Posted Thursday, February 9, 2012 9:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 8:41 AM
Points: 48, Visits: 266
"Reserve 1 Gigabyte (GB) of RAM for the Operating System (OS)"

Are you sure? Shouldn't it be 2GB?
Post #1249793
Posted Friday, February 10, 2012 6:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:14 PM
Points: 312, Visits: 1,106
Yes this is correct as per the authors of the book. Also, there is other memory reserved it not just 1GB of RAM.


Post #1250268
Posted Monday, April 30, 2012 7:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 8, 2014 5:37 AM
Points: 3, Visits: 123
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)?
Post #1292898
Posted Tuesday, June 26, 2012 2:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 12:41 PM
Points: 1, Visits: 76
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))
Post #1321541
Posted Wednesday, June 27, 2012 6:37 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:14 PM
Points: 312, Visits: 1,106
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,



Post #1321832
Posted Wednesday, June 27, 2012 6:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:14 PM
Points: 312, Visits: 1,106
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 :)



Post #1321834
Posted Tuesday, April 2, 2013 9:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 30, 2014 8:36 AM
Points: 69, Visits: 540
Thank you for the scripts. It was a great help for me.
Post #1437963
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse