Rob L-566658 (2/1/2010)
The information was collated, our test server was then aligned and the tests were run again - the difference was not showing as 20-30% gain :ermm: I did the same type of test on other arrays - RAID1 pairs, RAID1+0 sets and the results were inconsistent.Is there a better way to get reliable performance results? e.g. results that relate to real world gains or losses as our tests don't back up the official Microsoft data so we're left in a quandary over whether it's worth implementing the changes to production systems.
Thoughts?
Rob, what sort of results did you get? Was it better at all, worse?
I would say using SQLio and SQLioSim is a good way to go, plus just comparing perfmon results before and after. Perfmon would be showing throughput with your actual day to day workload.
---------------------------------------------------------------------