Re: Use a benchmark or compile a large project
If you had read the review you would have learned that I tried rather a lot of things. For months. Here are the benchmarks I've used.
Hammerora http://hammerora.sourceforge.net/ Microsoft SQL, MySQL, Postgres, OracleDB (if you have it).
OStrell http://blogs.msdn.com/b/psssql/archive/2014/04/24/version-9-04-0013-of-the-rml-utilities-for-x86-and-x64-has-been-released-to-the-download-center.aspx Microsoft SQL, as part of the SQL RML Utilities.
SQLIO http://www.microsoft.com/en-us/download/details.aspx?id=20163 This writes all zeros. It tells us a very specific thing about how "zero blocks" are dealt with. It's tricky. Follow http://www.mssqltips.com/sqlservertip/2127/benchmarking-sql-server-io-with-sqlio/ and http://www.brentozar.com/archive/2008/09/finding-your-san-bottlenecks-with-sqlio/
SQLIOSIM https://support.microsoft.com/en-us/kb/231619?wa=wsignin1.0 this is to test stability, not performance. https://www.simple-talk.com/sql/database-administration/the-sql-server-sqliosim-utility/
General disk tests
FIO http://freecode.com/projects/fio Read http://support.sas.com/resources/papers/proceedings13/479-2013.pdf and all will be revealed.
Iometer http://www.iometer.org/ Various configurations
Jetstress 2013 http://www.microsoft.com/en-ca/download/details.aspx?id=36849
Jetstress 2010 http://www.microsoft.com/en-ca/download/details.aspx?id=4167
Background work tests
Using iometer determine your peak global IOPS as per above test. Load the system to 25%, 33%, 50%, and 75% of IOPS capacity. Now run various common administrative tasks and time them.
1) Full VM backup using VM backup software
4) Creation of VM from template
5) SQLIO test runs on a single VM (testing mixed workloads!)
6) Exchange Jetstress (testing mixed workloads!)
7) SQLIO and Exchange Jetstress (testing mixed workloads!)