Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SBS2011 + SQL Server - Increase memory for SQL

Posted on 2011-09-21
3
Medium Priority
?
484 Views
Last Modified: 2012-05-12
We're running an SBS2011 server at a customers that has SQL 2008R2 loaded on it to run a production database.  The server has 24gb of memory in it however we've noticed that Exchange is using most of it... about 18gb only leaving about 2.3gb of space for SQL.  Is there a way to increase the amount of memory SQL uses helping to increase the speed.

Users notice a speed increase when I stop the information store and start it up again, temporarily releasing the memory used.  It seems to be a function of SBS to utilize as much memory as the server uses for Exchange,  a much smaller client is using over 8gb of exchange on a system with 12gb total mem.

Any help would be appreciated.
0
Comment
Question by:Fluid_Imagery
  • 2
3 Comments
 
LVL 25

Expert Comment

by:DBAduck - Ben Miller
ID: 36577829
You can set the maximum server memory for SQL to the amount you want to max out at so SQL does not take all the RAM, and then set the minimum server memory to a number that gives SQL Server the amount of RAM min that you want.

Here is how it works.  The SQL Server will request RAM when it needs it and when it gets it, it will give it back if the OS asks it.  But when you have the minimum memory set, then SQL Server will give back the RAM down to the minimum amount.  So if SQL Server gets 6 GB and you have the min set at 5 GB, the OS requests memory back, SQL will give back until it has only 5 GB allocated and won't give any more back.

So you may have to have SQL Server ramp up to get above the minimum and then Exchange can get some more after that, but that is the only thing I can suggest.
0
 

Author Comment

by:Fluid_Imagery
ID: 36577836
Where are the settings to change the Minimum and Maximum memory that SQL will use?
0
 
LVL 25

Accepted Solution

by:
DBAduck - Ben Miller earned 2000 total points
ID: 36577847
sp_configure 'show advanced', 1
reconfigure with override
sp_configure 'max server', number in MB
reconfigure with override
sp_configure 'min server', number in MB
reconfigure with override
sp_configure 'show advanced', 0
reconfigure
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question