Does SQLIO lie when run from a Hyper-V guest on a VHD?
Posted
by
ScottStonehouse
on Server Fault
See other posts from Server Fault
or by ScottStonehouse
Published on 2011-07-06T00:09:45Z
Indexed on
2012/09/27
15:40 UTC
Read the original article
Hit count: 286
SQLIO seems like a useful tool. I thought it would be interesting to try to measure the speed difference between a physical disk and a VHD. So I ran SQLIO on the Hyper-V host on the physical drive. Results seemed reasonable. Then I ran it from the guest to test the vhd (on the same physical disk). I expected it to be a bit slower. But instead it was way faster - like 0ms average latency.
So I'm trying to learn something here. It seems like hyper-v is fooling SQLIO somehow but I don't understand it well enough to figure it out.
It's a dynamic vhd, no snapshots or anything, and the vhd is the only file on the disk. The physical disk is actually a two SAS drive RAID 1.
© Server Fault or respective owner