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.