CPI-FDR-300G-26N.int.audit.2008-04-02.final.mag

Mag

Description

TPC-H Rev. 2.6.2 CPI Phoenix IQ-201 Report Date using EXASolution 2.0 April 2, 2008 Total System Cost Composite Query per Hour Metric Price / Performance 547,205.4 $ 1.05 $ 574,565 QphH@300GB $ / QphH@300GB Database Size Database Manager Operating System Other Software Availability Date 300 GB EXASolution 2.0 EXACluster OS 1.3 C++ Compiler April 2, 2008 Query Times in seconds2.9 10.2Q1Q2 Power TestQ3 Throughput Test Geometric Mean of Power TestQ4 Arithmetic Mean of Throughput TestQ5Q6Q7Q8Q9Q10Q11Q12Q13Q14Q15Q16Q17Q18Q19Q20Q21Q22RF1RF20 10 20 30 40 50 60 70 Database Load Time = 0.96 Included Backup: N Data Storage / Database Size = 23.56 RAID (Base tables only): Y RAID (Base tables and auxiliary data structures): Y RAID (All): Y System Configuration: 26 x CPI Phoenix IQ-201 server, each with: 2 Intel XEON X5365 QC 3.0 GHz processors (each is 1 chip, 4 cores, 4 threads) 12 GB RAM 2x 146 GB (10k rpm) internal SATA disks Total Storage: 7,070 GB (1 GB = 1024 * 1024 * 1024 bytes) TPC-H Rev. 2.6.2 CPI Phoenix IQ-201 Report Date using EXASolution 2.0 April 2, 2008 Extended 3 yr. Maint. Description Part Number Pricing Unit Price Qty Price Price System Hardware CPI-Phoenix-Server 2x 3.0 Ghz Quadcore CPUs (Intel® Xeon 5365) 16 FBDIMM-Slots IQ-201 ...

Informations

• Publié par: Orgio
• Nombre de lectures: 8
• Langue: English

Extrait

TPC-H Rev. 2.6.2

CPI Phoenix IQ-201

using EXASolution 2.0

Report Date

April 2, 2008

Total System Cost

Composite Query per Hour Metric

Price / Performance

$ 574,565

547,205.4

QphH@300GB

$ 1.05

$ / QphH@300GB

Database Size

Database Manager

Operating System

Other Software

Availability Date

300 GB

EXASolution 2.0

EXACluster OS 1.3

C++ Compiler

April 2, 2008

Query Times in seconds

10.2

2.9

0

10

20

30

40

50

60

70

RF2

RF1

Q22

Q21

Q20

Q19

Q18

Q17

Q16

Q15

Q14

Q13

Q12

Q11

Q10

Q9

Q8

Q7

Q6

Q5

Q4

Q3

Q2

Q1

Power Test

Throughput Test

Geometric Mean of Power Test

Arithmetic Mean of Throughput Test

Database Load Time = 0.96

Included Backup: N

Data Storage / Database Size = 23.56

RAID (Base tables only): Y

RAID (Base tables and auxiliary data structures): Y

RAID (All): Y

System Configuration:

26 x CPI Phoenix IQ-201 server, each with:

2 Intel XEON X5365 QC 3.0 GHz processors (each is 1 chip, 4 cores, 4 threads)

12 GB RAM

2x 146 GB (10k rpm) internal SATA disks

Total Storage:

7,070 GB

(1 GB = 1024 * 1024 * 1024 bytes)

TPC-H Rev. 2.6.2

CPI Phoenix IQ-201

using EXASolution 2.0

Report Date

April 2, 2008

Description

Part Number

Pricing Unit Price

Qty

Extended

Price

3 yr. Maint.

Price

System Hardware

CPI-Phoenix-Server

2x 3.0 Ghz Quadcore CPUs (Intel® Xeon 5365)

16 FBDIMM-Slots

12x 3.5˝ SAS/S-ATA HotSwap Slots

2x Ethernet Ports GBit

1x IPMI 2.0 Server Management

IQ-201

1

5,602

26+3

162,458

(3 spares)

2GB FBDIMM-667MHz

RAM-02

1

163

156+16

28,036

(16 spares)

3Ware 4 Port SATA Controller (+BBU incl.)

CTR-04

1

594

52+6

34,452

(6 spares)

150 GB S-ATA150 10.000 rpm

HD-150

1

220

52+6

12,760

(6 spares)

Ethernet Cable (RJ45 Cat-5E) 7 feet

CBL-07

1

8

52+6

464

(6 spares)

On-site replenishment within 7 days throughout the 3-year

maintenance period

SUP-01

1

Incl.

-

-

-

CPI Server Discount (20%)

-47,634

HP ProCurve 5406zl

+ redundant power supply

(1000Base-T Ethernet Switch, 72 ports)

HPE-072

1

1

9,967

HP 3 year 24x7, 4 hours Chassis 6 HW Support

HPE-072-SUP

1

2,437

Subtotal

$ 200,503

$ 2,437

Storage

No external storage required

Software

EXASolution 2.0 licence for 3 years

EXA-26N-12G

2

1

395,767

EXASOL Discount (10%)

2

-39,577

EXASOL Premium Support (3.9%)

EXA-SUP-P

2

15,435

Subtotal

$ 356,190

15,435$

Total

$ 556,693,

17,872$

3-Year Cost of Ownership

$ 574,565

QphH Rating:

547,205.4

$/QphH@300GB:

1.05

Price Key:

1-CPI, contact: Peter Markgraf, [e-mail]

2-EXASOL, contact: Olga Sapozhnykova, [e-mail]

All discounts are based on list prices and for similar quantities and configurations.

Results independently audited by:

Francois Raab of InfoSizing, Inc. (www.sizing.com)

Prices used in TPC benchmarks reflect the actual prices a customer would pay for a one-time purchase of the stated components. Individually

negotiated discounts are not permitted. Special prices based on assumptions about past or future purchases are not permitted. All discounts reflect

standard pricing policies for the listed components. For complete details, see the pricing sections of the TPC benchmark specifications. If you find

that the stated prices are not available according to these terms please inform the TPC at [e-mail].

TPC-H Rev. 2.6.2

CPI Phoenix IQ-201

using EXASolution 2.0

Report Date

April 2, 2008

Numerical Quantities

Measurement Results

Database Scale Factor

300 GB

Total Data Storage / Database Size

23.56

Start of Database Load

12:09:44

End of Database Load

13:07:15

Database Load Time

57m 31s

Query Streams for Throughput Test

11

TPC-H Power

376,927.3

TPC-H Throughput

794,407.3

TPC-H Composite Query-per-Hour Metric (QphH@300GB)

547,205.4

Total System Price Over 3 Years

$574,565

TPC-H Price/ Performance Metric ($/QphH@300GB)

$1.05

Measurement Interval

Measurement Interval in Throughput Test (Ts)

329 seconds

Duration of Stream Execution

Stream ID

Seed

Start Date

Start Time

End Date

End Time

Duration

Stream 0

331130715

2008-03-31

13:07:24

2008-03-31

13:09:02

1 mins:38secs

Stream 1

331130716

2008-03-31

13:09:06

2008-03-31

13:14:09

5 mins:03secs

Stream 2

331130717

2008-03-31

13:09:06

2008-03-31

13:14:02

4 mins:56secs

Stream 3

331130718

2008-03-31

13:09:07

2008-03-31

13:14:17

5 mins:10secs

Stream 4

331130719

2008-03-31

13:09:10

2008-03-31

13:14:17

5 mins:07secs

Stream 5

331130720

2008-03-31

13:09:11

2008-03-31

13:14:23

5 mins:12secs

Stream 6

331130721

2008-03-31

13:09:11

2008-03-31

13:14:30

5 mins:19secs

Stream 7

331130722

2008-03-31

13:09:13

2008-03-31

13:14:31

5 mins:18secs

Stream 8

331130723

2008-03-31

13:09:16

2008-03-31

13:14:30

5 mins:14secs

Stream 9

331130724

2008-03-31

13:09:17

2008-03-31

13:14:28

5 mins:11secs

Stream 10

331130725

2008-03-31

13:09:18

2008-03-31

13:14:31

5 mins:13secs

Stream 11

331130726

2008-03-31

13:09:19

2008-03-31

13:14:35

5 mins:16secs

Refresh

2008-03-31

13:09:03

2008-03-31

13:14:27

5 mins:24secs

TPC-H Rev. 2.6.2

CPI Phoenix IQ-201

using EXASolution 2.0

Report Date

April 2, 2008

TPC-H Timing Intervals (in seconds)

Query

Power

Stream

1

Stream

2

Stream

3

Stream

4

Stream

5

Stream

6

Stream

7

Stream

8

Stream

9

Stream

10

Stream

11

Min S

i

Avg S

i

Max S

i

1

5.0

43.1

42.9

37.0

40.8

40.0

41.9

38.5

38.7

41.5

40.1

43.1

37.0

40.7

43.1

2

0.9

6.8

3.9

6.2

6.7

4.4

5.3

5.6

5.9

4.8

6.3

5.0

3.9

5.5

6.8

3

2.7

8.1

14.6

13.7

11.9

15.3

13.7

12.5

15.3

13.2

11.1

13.7

8.1

13.0

15.3

4

1.1

7.2

7.9

6.6

5.9

6.7

7.7

6.4

6.7

6.9

7.3

6.5

5.9

6.9

7.9

5

4.8

14.3

14.9

13.1

8.4

13.6

18.1

15.0

13.4

13.8

8.2

14.9

8.2

13.4

18.1

6

1.0

7.4

1.8

8.8

7.9

7.2

7.2

7.9

7.8

6.7

7.7

5.3

1.8

6.9

8.8

7

3.7

19.5

16.0

19.1

14.7

18.8

21.1

17.6

19.9

17.4

17.8

9.3

9.3

17.4

21.1

8

4.2

10.0

10.1

4.1

10.8

13.3

10.7

13.5

11.4

8.1

10.4

12.7

4.1

10.5

13.5

9

15.7

46.5

48.5

49.4

53.7

46.3

55.1

52.1

59.1

58.4

60.3

61.8

46.3

53.8

61.8

10

2.8

15.3

13.7

15.4

14.2

18.4

12.6

16.1

16.6

13.4

12.0

14.0

12.0

14.7

18.4

11

4.2

8.5

8.8

8.8

9.1

10.0

9.8

12.5

5.6

11.6

9.7

10.6

5.6

9.5

12.5

12

2.6

15.6

14.3

13.8

12.2

14.9

13.8

8.2

13.6

12.4

11.1

14.6

8.2

13.1

15.6

13

3.1

17.0

15.2

18.2

14.6

15.3

17.6

16.1

18.5

15.5

17.2

16.3

14.6

16.5

18.5

14

3.4

14.0

7.6

11.6

12.8

14.2

12.6

12.9

9.5

9.8

11.6

12.9

7.6

11.8

14.2

15

4.5

17.1

15.4

15.8

18.5

18.2

15.9

16.9

17.6

19.4

17.6

18.6

15.4

17.4

19.4

16

5.9

10.5

11.1

11.5

12.3

12.2

11.2

13.2

12.9

9.1

13.7

11.5

9.1

11.7

13.7

17

1.0

3.4

1.1

4.5

2.8

5.0

3.1

4.5

3.4

3.5

4.2

5.6

1.1

3.7

5.6

18

6.0

16.5

17.2

18.6

18.8

15.3

17.0

16.2

11.5

15.9

14.5

17.6

11.5

16.3

18.8

19

1.5

3.7

4.2

4.6

7.0

4.0

4.1

3.2

2.6

4.4

5.9

2.0

2.0

4.1

7.0

20

2.2

10.9

12.2

11.8

7.0

10.6

7.3

11.1

9.5

10.6

8.8

8.9

7.0

9.9

12.2

21

1.8

4.5

12.7

14.0

14.1

6.7

10.1

14.8

12.1

11.4

14.3

9.1

4.5

11.3

14.8

22

0.4

2.9

2.1

3.8

2.4

2.0

2.9

2.9

2.6

3.2

3.1

2.1

2.0

2.7

3.8

RF1

16.8

37.4

23.5

19.8

23.6

23.9

21.2

21.6

23.1

24.3

22.2

22.5

19.8

23.9

37.4

RF2

2.7

5.4

5.8

4.8

6.0

5.4

4.5

6.1

6.2

7.6

5.2

3.7

3.7

5.5

7.6