I hope this has a really simple solution, but I have a feeling it won't. I've not been able to find any information on this anywhere else, which isn't a good start!
Basically we're running SQL Server 2008 on a Windows Server 2008 R2 machine with 16GB RAM.
The problem is that our RAM usage keeps creeping up to 15.6GB and causing us problems, and I was wondering if it could be SQL's cache.
We've now configured SQL to use a min/max of 13GB, but I'm still worried that it might be something else eating the RAM, so before I reset the server and flush out whatever is using it, I thought I'd try and see if it was SQL behind it.
How can I see the size of SQL's cache RAM usage? Is it just the figure in the task manager?
Thanks for any help.