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: 284

Filed under:
|
|
|

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

Related posts about hyper-v

Related posts about storage