In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Course Of The Month
10 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SBS2011 + SQL Server - Increase memory for SQL
Posted on 2011-09-21
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.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
After hours on line I found a solution which pointed to the inherited Active Directory permissions . You have to give/allow permissions to the "Exchange trusted subsystem" for the user in the Active Directory...
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it.
The vast majority of email clients display l…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 5 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.