Intel RAID Performance 12Gb/s SAS RAID Controllers

Intel®RAIDPerformance12Gb/sSASRAIDControllersWhitePaper
2.4 Microsoft® SQL Server 2014 OLTP Benchmarking
 IOmetersimulationcharacterizesperformancewell,howeverrealapplicationshavemultiplesystem 
 interactionsthatarehardtocaptureinanarticialbenchmark.Todeterminethetruedatabase 
 capabilitiesoftheIntel12Gb/sSASRAIDcontroller,itwasmeasuredusingaMicrosoft®SQLServer2014
database and a standard benchmark that exercises complex transactional operations modeled after a
brokerage house. This benchmark allowed measurements and observations of the Intel RAID SSD cache
 benetsfromonetofourSSDs,asshowninthefollowingstepsandcharts.
 1. Databaseloadedwithdatafor10,000customers.
2. Baseline measurement taken with only SAS HDDs.
 3. AddedSSDs1to3(forRAID0),and2and4(forRAID10),conguredwithbothreadandwrite
caching and assigned to the database volume.
 4. Testsranforfourhours.Aftereachfour-hourrun,theaveragetransactionspersecondandthe
SQL Server Page IO Latch Wait Time was recorded.
5. The database was restored to its original state. The results are quite astounding.
Figure 7 Intel Integrated RAID Module RMS3CC080 Microsoft SQL Server 2014 OLTP Benchmark
 ThreedisksinaRAID0SSDcachevolumeprovidedthehighestincreaseof381%,andevenaprotectedRAID10
 producedaverygenerous167%increaseinthenumberofachievedtransactions.UsingtheSSDcachefeatureisone
 ofthemostcosteectivewaystoenhanceapplicationperformance,especiallywhenworkingwithhotuserdata.