Dell POWEREDGE R720XD - Manual (Page 13)

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on
PowerEdge R720xd
13
Figure 8. SQLIO Real Rate Test from Disk (Large 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: 379 MB/s
H710P PERC Controller
Synthetic I/O rate: 2014 MB/s
SQL Server 2012 Enterprise
Single Socket Intel four core
Aggregate Synthetic I/O rate: 2014 MB/s
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 10
Fast Track Database Validation
The performance of a Fast Track database configuration is measured using two core metrics: Maximum
CPU Consumption Rate (MCR) and Benchmark Consumption Rate (BCR).
Calculating MCR
MCR indicates the per core I/O throughput in MB or GB per second. This is measured by executing a
pre-defined query against the data in the buffer cache, and measuring the time taken to execute the
query against the amount of data processed in MB or GB. MCR value provides a baseline peak rate for
performance comparison and design purposes.
For the validated configuration with one Intel E5-2643 four core processors, the system aggregate MCR
was 1244 MB/s. The realized MCR value per core was 311 MB/s.
Calculating BCR
BCR is calculated in terms of total read bandwidth from the storage hard drives and not from the
buffered cache as in the MCR calculation. This is measured by running a set of standard queries specific
to the data warehouse workload. The queries range from I/O intensive to CPU and memory intensive,
and provide a reference to compare various configurations.