HyperVisor - ESXi 6.7U3
Mostly Windows VMs
I’m sure there’s good reason for this and it's probably to do with the way SQL handles memory but when I check the memory usage from Prism or Prism Central for a VM that’s running SQL it’s not accurately reflecting what the VM is actually using. For example, from within the VM if I fire up task manager or even perfmon it will report the memory usage at say 95% whereas from Prism it reports the VM as using 25%.
I need to generate a report for a collection of SQL VMs and application servers but I think for the SQL VMs I'm going to have to provide perfmon screenshots or something.
Can anyone explain to me in simple terms why this is happening?