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
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.
- Inspiron 530 (2 pages)
- OptiPlex 755 (45 pages)
- OptiPlex 755 (248 pages)
- OptiPlex 755 (622 pages)
- OptiPlex 755 (528 pages)
- OptiPlex 755 (82 pages)
- OptiPlex 760 (203 pages)
- OptiPlex 760 (76 pages)
- OptiPlex 745 (212 pages)
- OptiPlex 745 (360 pages)
- OptiPlex 745 (428 pages)
- OptiPlex 780 (74 pages)
- OptiPlex 780 (80 pages)
- OptiPlex 780 (73 pages)
- OptiPlex 780 (40 pages)
- OptiPlex 780 (14 pages)
- OptiPlex 780 (89 pages)
- OptiPlex 780 (10 pages)
- OptiPlex GX620 (221 pages)
- OptiPlex GX620 (294 pages)
- OptiPlex GX620 (338 pages)
- Inspiron 530 (226 pages)
- OptiPlex 960 (Late 2008) (16 pages)
- OptiPlex GX260 (100 pages)
- OptiPlex GX260 (235 pages)
- OptiPlex FX160 (Late 2008) (20 pages)
- OptiPlex FX160 (Late 2008) (132 pages)
- OptiPlex FX160 (20 pages)
- OptiPlex 210L (130 pages)
- OptiPlex 210L (128 pages)
- OptiPlex 210L (300 pages)
- OptiPlex 210L (258 pages)
- OptiPlex 210L (150 pages)
- OptiPlex 320 (132 pages)
- OptiPlex 320 (312 pages)
- OptiPlex 320 (266 pages)
- OptiPlex 320 (356 pages)
- OptiPlex 320 (44 pages)
- OptiPlex 320 (140 pages)
- OptiPlex GX240 (298 pages)
- OptiPlex GX240 (182 pages)
- OptiPlex GX240 (144 pages)
- OptiPlex GX240 (121 pages)
- OptiPlex GX240 (86 pages)
- OptiPlex GX240 (283 pages)