I've been going back and forth with this issue for some time but honestly I have no idea if the vCenter telemetry is something to rely on. I'm experiencing rather high latency on the storage on my VMs, most of them idle, only vCenter and virtual firewall generate some IOPS, 5 are shut down, other 3 VMs are linux machines that idle for 99%, even though they can spike 100ms per IO. Today I have decided to migrate a VM storage to another server to find that higher disk utilization reduces the latency on the host, how that makes any sense? I'm using P420 in RAID 10 with 4x4TB 7k SAS HDDs.
Host latency:
https://preview.redd.it/cqvmy550ty1c1.png?width=986&format=png&auto=webp&s=f5823391eb6cd82cb9612b44aa2768087bf619e1
15-30ms latency seems reasonable for that hardware (P420 in RAID 10 with 4x4TB 7k SAS HDDs.)
Basically your single SAS disk can do ~150IOPS random, so worst case of 4k random reads you will get ~600KBps.
For the migration if it's sequential (depending on filesystem layout), the performance can be different, up to maximum streaming performance of like 100MBs for large sequential reads.
Then 2x for your RAID config.
GID VMNAME NVDISK CMDS/s READS/s WRITES/s MBREAD/s MBWRTN/s LAT/rd LAT/wr
12953 dns - 1 0.00 0.00 0.00 0.00 0.00 0.000 0.000
16904 fw - 2 5.84 0.00 5.84 0.00 0.02 0.000 18.408
20481 vcsa - 13 16.58 0.00 16.58 0.00 0.08 0.000 37.582
130847 - 2 0.00 0.00 0.00 0.00 0.00 0.000 0.000
626694 deb - 2 12.06 0.00 12.06 0.00 0.46 0.000 6.586
as you can see the is no much IOPS per VM, like vcsa VM latency I captured is floating between 20 and 100ms, while deb has similar IOPS but lower latency
I think what you want to do is go into your db vm and run a DD or fio or bonnie++ that is at least 2 x the VM RAM, and see what the steady-state disk performance is.
I don’t have db VM, I think you are referring to deb which is short for Debian.