Just to test, I ran SQLIO
on a windows 2008 box (DL785) local disk (4x300G, RAID 10) vs a Netapp aggregate of 56 disks. Filer is running 7.2.6.1, this is a FC LUN. Aggregate is not really that loaded.
Surprisingly to me, the results show the C drive to be faster. I know there are various ways to tweak SQLIO but I still find this odd. Any suggestions would be appreciated:
SQLIO: 1 thread reading for 30 secs using 2KB IOs over 128KB stripes with 64 IOs per run:
Local C:\ [sqlio -dC]
IOs/sec: 5844.79
MBs/sec: 11.41
Netapp F:\ [sqlio -dF]
IOs/sec: 2547.88
MBs/sec: 4.97
SQLIO: 1 thread writing for 30 secs using 2KB IOs over 128KB stripes with 64 IOs per run:
Local C:\ [sqlio -kW -dC]
IOs/sec: 10116.73
MBs/sec: 19.75
Netapp F:\ [sqlio -kW -dF]
IOs/sec: 1895.42
MBs/sec: 3.70