I'm running SQL 2008 on a 2008 R2 server and no matter how much memory I give the VM it will use 95% of it. The server doesn't have any additional roles it fills and is dedicated to primarily SQL role.
What is the best way to determine / control the amount of memory I should give to the VM without having any performance issues. It currently has 24 and I can give it more if needed but just not a database expert.
Joel T Brown