Dell PowerEdge External Media System 1434 Configuration

Also see for PowerEdge R720xd: Technical guide Technical guide Technical guide Getting started guide Owner's manual

Contents

Dell PowerEdge External Media System 1434 Configuration Manual pdf 13 page image

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse onPowerEdge R720xd13Figure 8. SQLIO Real Rate Test from Disk (Large File)POWER EDGE R720-XDPERC H700ControllerINTERNAL STORAGERAID 1Windows Server 2008 R2 SP1SQL Server 2012Intel E5-26434 coreCPUSingle RAID 1 Disk GroupSynthetic I/O rate: 379 MB/sH710P PERC ControllerSynthetic I/O rate: 2014 MB/sSQL Server 2012 EnterpriseSingle Socket Intel four coreAggregate Synthetic I/O rate: 2014 MB/sRAID 1RAID 1RAID 1RAID 1RAID 1RAID 1RAID 1RAID 1RAID 10Fast Track Database ValidationThe performance of a Fast Track database configuration is measured using two core metrics: MaximumCPU Consumption Rate (MCR) and Benchmark Consumption Rate (BCR).Calculating MCRMCR indicates the per core I/O throughput in MB or GB per second. This is measured by executing apre-defined query against the data in the buffer cache, and measuring the time taken to execute thequery against the amount of data processed in MB or GB. MCR value provides a baseline peak rate forperformance comparison and design purposes.For the validated configuration with one Intel E5-2643 four core processors, the system aggregate MCRwas 1244 MB/s. The realized MCR value per core was 311 MB/s.Calculating BCRBCR is calculated in terms of total read bandwidth from the storage hard drives and not from thebuffered cache as in the MCR calculation. This is measured by running a set of standard queries specificto the data warehouse workload. The queries range from I/O intensive to CPU and memory intensive,and provide a reference to compare various configurations.

/ 16

Related manuals for Dell PowerEdge R720xd