I have to migrate from a physical SQL server to a VMWare virtual server.
My current server while older is well equipped with many cores and a decent amount of RAM.
My server guy always says why do you need so much ram and cpus.
He says, I only see the average CPU usage at 25%.
So I need to adequately back up my need for more RAM and processing power some how. I was hoping I could use DPA to report on how adequate my existing server is.
What would best practice be in this case?