9
2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad Weiss 09.05.2012 27.04.2012 Beste Skalierbarkeit dank massiv paralleler Verarbeitung mit "Parallel Data Warehouse" (PDW) 1

2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

Embed Size (px)

Citation preview

Page 1: 2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

2012 © Trivadis

Beste Skalierbarkeit dank massiv paralleler Verarbeitung mit "Parallel Data Warehouse" (PDW)1

BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN

TechTalk WrapUp, Q&A

Mark WunderliMeinrad Weiss

09.05.2012

27.04.2012

Page 2: 2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

2012 © Trivadis

Beste Skalierbarkeit dank massiv paralleler Verarbeitung mit "Parallel Data Warehouse" (PDW)2

Things to remember

1. FastTrack Do more with less

- Cost efficient, well balanced systems- Simple migration

2. Database Consolidation Appliance “Clean up” and simplify management Provide flexible self service options Bring the cloud to your computer center

3. Parallel Data Warehouse Massive scalabiltiy Close to SQL Server Optimal integration in an existing Microsoft environment

27.04.2012

Page 3: 2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

Faster time-to-value

Fast Track delivery via HP Factory Express

System customizatio

n

Software integration

Solution services

• Hardware and rack configurations

• Custom system settings

• Cabling• Asset tagging and

labeling

• Software load and configuration

• Third-party applications

• Solution-level testing

• Single point of contact

• On-site set-up and activation

• Project management• Engineering and

logistics

Page 4: 2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

HP + MICROSOFT SQL SERVER APPSYSTEMS

2011-Q4 2012-1Q 2012-2Q 2012-3Q 2012-4Q 2013-1Q 2013-2Q

© 2012 HP Confidential HP Confidential – Subject to CDA and Change Without Notice

Fast Track 4.0

DBCA 2.0

Appliance SQL Server 2012

FT

DBCADBCA

PR OC

2

PR OC

1

8

9

6

7

4

5

2

31

2

1

4

3

6

5

8

79

12344321

OV ERT EM P

PO WE RCAP

ON LIN ESPARE

M IRR OR 5

2PS 1PS

UID

31

26

45

87

31

26

45

87

HPProLiantDL370 G6

SAS

6G DP

10k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

B

SAS

6G DP

10k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

B

SAS

6G DP

10k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

BSA

S6G

DP 10

k

30

0 G

B

EDW 1.2

FT 3.0

OLTP RA OLTP

RA SQL Server 2008 R2

G8, P2000, SQL 2012

G8, P2000, SQL 2012, MSSC 2012

EDW 1.3SW updatesHalf Rack option

EDW 1.4G8, Storage, Networking, SW updates

2 Appliances / 5 RAs80% faster reports95% faster queries 50% faster deployment

Consolidate1000s of DBs75% opex savings Provision DBs in minutes vs weeks

EDW

Page 5: 2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

Learn More

• HP Fast Track Reference Architecture 3.0 http://www.hp.com/solutions/microsoft/fasttrack

• HP Enterprise Database Consolidation Appliance page http://www.hp.com/solutions/microsoft/dbc

• Microsoft Database Consolidation Appliance page http://www.microsoft.com/sqlserver/en/us/solutions-technologies/Appliances/HP-dca.aspx

• Quick ROI calculator for DBCA benefit… http://www.hp.com/aquarius/ROI_CALCULATOR/Microsoft-DBCA/index.html

• HP/Microsoft Database Consolidation Appliance TCO Whitepaper http://www.hp.com/solutions/microsoft/dbc

• HP Database Consolidation Appliance Datasheet http://h20195.www2.hp.com/V2/GetDocument.aspx?docname=4AA3-7250ENW&cc=us&lc=en

• HP Service Consulting – SQL Server Consolidation and Virtualization http://h20195.www2.hp.com/v2/GetPDF.aspx/4AA2-1157ENW.pdf

55

Page 6: 2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

2012 © Trivadis

Beste Skalierbarkeit dank massiv paralleler Verarbeitung mit "Parallel Data Warehouse" (PDW)6

Added Value of Trivadis

Multiple PDW and DBC Lead Architects

> 15 Educated Solution Specialists

Huge experience with SQL Server and with parallel systems like Exadata, Teradata and Co.

SLA on top of Microsoft and HP’s offering

27.04.2012

Hardware(HP, DELL, …)

Software ((Windows, SQL Server)(Microsoft

Application(Trivadis)

Application Careon the wholeStack

Page 7: 2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

2012 © Trivadis

Beste Skalierbarkeit dank massiv paralleler Verarbeitung mit "Parallel Data Warehouse" (PDW)7

Typical Project Phases

Idea POCDetailed System

ConfigurationSetup Operation

27.04.2012

Talk with usMicrosoftTrivadis

HP

Page 8: 2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

2012 © Trivadis

Beste Skalierbarkeit dank massiv paralleler Verarbeitung mit "Parallel Data Warehouse" (PDW)8

BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN

Merci!

Thank you!

Grazie mille!

VIELEN DANK!

Trivadis AG

Konrad HäfeliMeinrad WeissStephan Hurni

[email protected]

27.04.2012

Page 9: 2012 © Trivadis BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN TechTalk WrapUp, Q&A Mark Wunderli Meinrad

THANK YOU