Figure 7, Sqlio line rate test from cache (small file), Power edge r720-xd – Dell POWEREDGE R720XD User Manual

Page 12

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on
PowerEdge R720xd

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.