<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Rudy Panigas
»
Calculate the values for MAX Memory for SQL...
Calculate the values for MAX Memory for SQL Server
Rate Topic
Display Mode
Topic Options
Author
Message
Rudy Panigas
Rudy Panigas
Posted Tuesday, December 20, 2011 2:13 PM
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 5:32 PM
Points: 306,
Visits: 1,013
Comments posted to this topic are about the item
Calculate the values for MAX Memory for SQL Server
Post #1224761
pkrudysz
pkrudysz
Posted Thursday, February 09, 2012 9:26 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:10 AM
Points: 48,
Visits: 257
"Reserve 1 Gigabyte (GB) of RAM for the Operating System (OS)"
Are you sure? Shouldn't it be 2GB?
Post #1249793
Rudy Panigas
Rudy Panigas
Posted Friday, February 10, 2012 6:57 AM
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 5:32 PM
Points: 306,
Visits: 1,013
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
Tec_Chief
Tec_Chief
Posted Monday, April 30, 2012 7:28 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 10:32 AM
Points: 3,
Visits: 119
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
scweichel
scweichel
Posted Tuesday, June 26, 2012 2:31 PM
Forum Newbie
Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 1,
Visits: 53
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
Rudy Panigas
Rudy Panigas
Posted Wednesday, June 27, 2012 6:37 AM
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 5:32 PM
Points: 306,
Visits: 1,013
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
Rudy Panigas
Rudy Panigas
Posted Wednesday, June 27, 2012 6:40 AM
Old Hand
Group: General Forum Members
Last Login: 2 days ago @ 5:32 PM
Points: 306,
Visits: 1,013
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
nisha_rana
nisha_rana
Posted Tuesday, April 02, 2013 9:21 AM
Valued Member
Group: General Forum Members
Last Login: Monday, May 06, 2013 7:59 AM
Points: 69,
Visits: 519
Thank you for the scripts. It was a great help for me.
Post #1437963
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
