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

Page 12

Advertising
background image

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.

Advertising