SQL Server 2014 only using 10 percent of its available memory? Hoping someone can weigh in here. I have a 2014 developer edition box that doesn't seem to be performing well. I currently have 128 GBs of RAM allocated to the box and 120 GBs maximum allocated inside of SQL itself.
When I look at the server itself, Windows recognizes it and so does SQL, but it never seems to jump up above 10 percent. All of the other SQL boxes I've built have memory at least sitting at 90 percent or so.
It's running a QA environment that sees maybe 10 users on it at one given time, but I would expect our memory to be using a lot more than it is currently. Any ideas?
if you what that sql server reservs an amount of ram you have to configure minimum server memory.
In your case the min server memory is zero; then sql server takes only the ram it nees to answer the users' queries.
Change it in this way:
EXEC sp_configure N'min server memory (MB)', MBs_you_like
RECONFIGURE