At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.
SBS2011 + SQL Server - Increase memory for SQL
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.
Asked:
2
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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.