Optimizing SQL Server Storage Performance Whitepaper
The new Dell™ PowerEdge™ R720 server was designed as a high-performance and scalability server. These features make it a perfect match for medium to large database application servers. Accompanying the release of the PowerEdge R720 are two new storage solutions, the Dell PERC H710P dual-core RAID controller that supports enterprise 6GB/s SAS solid-state drives (SSDs) and PowerEdge Express Flash PCIe SSD devices. With the introduction of faster Enterprise SAS SSDs and Dell PowerEdge Express Flash PCIe SSDs, the R720 dramatically improves random I/O (input/output) performance that has limited OLTP database performance in the past. This test report evaluates the performance benefits of both the PERC H710P controller with multiple drive types, and Express Flash PCIe-SSDs using a simulation of the I/O workload of a medium-sized Microsoft
® SQL Server ® TPC-E-like OLTP database.