We have a BI solution in Place.
SQL Server 2008 R2 for the DB and Sharepoint/Excel Front end.
Server has 32GB RAM, 2 CPU's.
SQL constantly runs at 31.5GB RAM or higher. This causes any reports on the front end to freeze due to insufficient Memory.
The only way to resolve is to restart the server. Which works for a few hours then runs out of Memory again.
I know SQL will use all available RAM available, but shouldn't it release it when it isnt using it? I don't feel having to kick the server every few hours is an adequate solution.