<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
»
SQL Server 2008
»
SQL Server 2008 - General
»
SQL Server Memory - High
SQL Server Memory - High
Rate Topic
Display Mode
Topic Options
Author
Message
NJDave
NJDave
Posted Tuesday, December 18, 2012 7:27 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:58 AM
Points: 55,
Visits: 339
Hello
I am running a physical server dedicated to SQL Server 2008 SP2 on
windows 2008 Enterprise Edition 64bit SP2 with 48GB RAM and my memory usage is staying at 47.2 GB.
Running EXEC sp_configure shows
name max server memory (MB)
minimum 16
maximum 2147483647
config_value 44000
run_value 44000
If I am reading this correctly, the max setting is already at the recomended setting of 44000 for 48 GB of physical RAM.
Is my memory usage normal? Do I have a problem - what should I look into?
If I need to get cooperation from the windows admin, where do I ask him to start looking?
In Resource Monitor, sqlservr.exe is using 46,710,000 KB of memory so I'm sure the problem is SQL.
Any clarification is appreciated.
Thanks
Dave
Post #1397787
anthony.green
anthony.green
Posted Tuesday, December 18, 2012 7:54 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
SQL will use memory from outside of the buffer pool, things like CLR for example use additional memory, so even though it is capped, it can go over by usually 2GB depending on the RAM needed.
I would recommend reading Chapter 4 of the Accidental DBA guide (link in my signature) which goes into memory management.
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1397811
GilaMonster
GilaMonster
Posted Tuesday, December 18, 2012 7:54 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:51 AM
Points: 37,738,
Visits: 30,010
NJDave (12/18/2012)
Is my memory usage normal? Do I have a problem - what should I look into?
Yes it is. No, you do not.
At most you may want to drop max server memory down a little. 44GB on a server with 48GB is a little high.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1397813
NJDave
NJDave
Posted Tuesday, December 18, 2012 9:31 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:58 AM
Points: 55,
Visits: 339
Thank you for the help - reading Chapter 4 now.
Thanks
Dave
Post #1397880
ScottPletcher
ScottPletcher
Posted Tuesday, December 18, 2012 10:00 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 3:56 PM
Points: 1,324,
Visits: 1,778
44 out of 48 is definitely too high. Keep in mind that the OS needs some RAM to manage the RAM itself.
Assuming no other software using significant RAM is running on that box to any significant degree, I'd suggest capping at no more than 40GB.
SQL DBA,SQL Server MVP('07, '08, '09)
One man with courage makes a majority. Andrew Jackson
Post #1397895
NJDave
NJDave
Posted Tuesday, December 18, 2012 11:27 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:58 AM
Points: 55,
Visits: 339
Thank you - I will cut it down to 40gb.
44 is what it was set at and I see that setting advised here...
http://www.sqlservercentral.com/blogs/glennberry/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008/
Thanks
Dave
Post #1397954
GilaMonster
GilaMonster
Posted Tuesday, December 18, 2012 1:16 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:51 AM
Points: 37,738,
Visits: 30,010
I prefer a conservative approach to memory. Set max server memory lower (the 40 out of 48) and if monitoring shows available memory, increase it slightly. Repeat until happy.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1397999
Mani Dev
Mani Dev
Posted Tuesday, December 18, 2012 2:26 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: 2 days ago @ 7:58 AM
Points: 169,
Visits: 427
Suppose Says you Have XGB of memory
I prefer 6GB for OS and the Remaining (X-6)GB for SQL by default on any server.
This will not work for Ram less than 10GB.
Post #1398045
GilaMonster
GilaMonster
Posted Tuesday, December 18, 2012 3:55 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:51 AM
Points: 37,738,
Visits: 30,010
That's too much for low memory servers and too little for high memory servers.
Chapter 4:
http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1398085
« 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.
