Dell POWEREDGE R720XD - Manual (Page 12)

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on
PowerEdge R720xd
12
SQLIO. This test verifies the maximum bandwidth available in the system to ensure no bottlenecks are
within the data path.
Figure 7. SQLIO Line Rate Test from Cache (Small File)
POWER EDGE R720-XD
PERC H700
Controller
INTERNAL STORAGE
RAID 1
Windows Server 2008 R2 SP1
SQL Server 2012
Intel E5-2643
4 core
CPU
Single RAID 1 Disk Group
Synthetic I/O rate: 2669 MB/s
H710P PERC Controller
Synthetic I/O rate: 2700 MB/s
SQL Server 2012 Enterprise
Single Socket Intel four core
Aggregate Synthetic I/O rate: 2700 MB/s
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 10
The second synthetic I/O test with SQLIO was performed with a large file to ensure reads are serviced
from the storage system hard drives instead of from cache. Figure 8 shows the maximum real rate that
the system is able to provide with sequential reads.