Figure 6, Sqlio line rate test from cache (small file), Power edge r510 – Dell PowerEdge R510 User Manual
Page 12

Dell R510 Reference Configuration for Microsoft SQL Server® 2008 R2 Fast Track Data Warehouse
Page 10
Figure 6. SQLIO Line Rate Test from Cache (Small File)
POWER EDGE R510
PERC H700
Controller
INTERNAL STORAGE
RAID 1
Windows Server 2008 R2 SP1
SQL Server 2008 R2
Intel X5675
6 core
CPU
RAID 1
RAID 1
RAID 1
RAID 1
Single RAID 1 Disk Group
Synthetic I/O rate: 1005 MB/s
H700 PERC Controller
Synthetic I/O rate:3707 MB/s
SQL Server 2008 R2 Enterprise
Single Socket Intel six core
Aggregate Synthetic I/O rate: 3873 MB/s
The second synthetic IO test with SQLIO was performed with a large file to ensure reads are serviced
from the storage system hard drives instead of from cache. This shows the maximum real rate that the
system is able to provide with sequential reads.