Dell PowerEdge External Media System 1434 Конфигурация - Страница 13

Просмотреть онлайн или скачать pdf Конфигурация для Сервер Dell PowerEdge External Media System 1434. Dell PowerEdge External Media System 1434 16 страниц. Statement of volatility
Также для Dell PowerEdge External Media System 1434: Руководство по началу работы (12 страниц), Руководство (38 страниц), Руководство (29 страниц), Использование руководства (16 страниц), Руководство (10 страниц)

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

PowerEdge R720xd

Figure 8.

SQL Server 2012 Enterprise

Single Socket Intel four core

Aggregate Synthetic I/O rate: 2014 MB/s

H710P PERC Controller

Synthetic I/O rate: 2014 MB/s

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.

SQLIO Real Rate Test from Disk (Large File)

POWER EDGE R720-XD

SQL Server 2012

Windows Server 2008 R2 SP1

Intel E5-2643

4 core

CPU

INTERNAL STORAGE

PERC H700

Controller

RAID 1

Single RAID 1 Disk Group

RAID 1

Synthetic I/O rate: 379 MB/s

RAID 1

RAID 10