Dell PowerEdge R720xd Manuel d'utilisateur télécharger pdf (Page 13)

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

PowerEdge R720xd

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 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.

1 2 ... 8 9 10 11 12 13 14 15 16

Pas de commentaire

Dell PowerEdge R720xd Manuel d'utilisateur Page 13