I preparing to move my dBs from a limited capacity captive RAID5 to a much larger capacity SAN. Some SAN I/O alarm bells went off in my head when it took 3 mins 45 secs to copy a single 4.3GB file from the data LUN (snapdrive D
to the log file LUN (snapdrive E
on the new server. I want to generate some I/O stats to compare the captive RAID5 with the proprietary double parity RAID on the SAN.
SQLIO does work - I was looking at using the latest SQLIO simulator.