Server 2012 CDPB298 Stephan Schnellinger Laurence Grizaud HansJuergen Fuks Agenda ConvergedSystem portfolio overview Virtualization DB consolidation Deep dive on two selected SQL based solutions ID: 586677
Download Presentation The PPT/PDF document "Converged Systems engineered for Microso..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1Slide2
Converged Systems engineered for Microsoft Windows Server 2012
CDP-B298Stephan SchnellingerLaurence GrizaudHans-Juergen FuksSlide3
Agenda
ConvergedSystem portfolio overviewVirtualization
DB consolidation
Deep dive on two selected SQL based solutions
HP Converged System 300 for Microsoft Analytics Platform
MS SQL Server 2014 on the HP ProLiant DL580 Gen8Slide4
Converged System overviewSlide5
HP ConvergedSystems evolution
Storage
Servers
Networking
Security
Management software
Services
CloudSystem
CloudSystem
ConvergedSystems
AppSystem
VirtualSystemSlide6
Servers
Software
Network
Storage
Converged Infrastructure
Converged System
Services
Private Cloud Systems
Virtualization Systems
Big Data Systems
Parts
Experience
What’s a Converged System
?Slide7
Virtualization
HP ConvergedSystem
for Virtualization
HP ConvergedSystem
for DB consolidation
Cloud
HP CloudSystem
Big Data
HP
ConvergedSystem
for
MS APS
HP ConvergedSystem
for SAP HANA
Built on the industry’s best
converged infrastructure with leading ISVs
The new HP
ConvergedSystem
portfolio
Delivering a breakthrough total systems experienceSlide8
Simple to buy
Simple to deploy
Simple to manage
Order to operations in as few
as
20 days
Managed
as
one
50–1,000+ VMs
Simple to support
One
company
:
HP
Costs
~30%
L
ower entry point
Based on estimated list prices, and software license
cost savings
HP
ConvergedSystem
CS700x for
Virtualization
The
fastest
way to virtualize with breakthrough TCO
on
a cloud-compatible
platformSlide9
HP ConvergedSystem CS700x for DB consolidation
Reducing the data center footprint and
computing
costs
Starting your virtualization journey
Standardizing technology in remote offices/branch offices (ROBOs)
Scaling storage capacity to multiple terabytes
Moving to a networked storage environment
Consolidating databases enterprise-wide
Providing mission-critical application supportSlide10
HP Converged System 300 for
Microsoft Analytics PlatformSlide11
Agenda
Short refresh on FasttrackChange in the datawarhouse worldConvergedSystem 300 for Microsoft APS Slide12
Microsoft SQL Server 2012
Fast Track Data Warehouse solutions
DL380p Gen8 + MSA2040
DL580G7 + P2000
DL560p Gen8 + P2000
DL380p Gen8 + 3PAR
DL980G7 + P2000
30TB
DL380p Gen8 +
int
SSD
4/11TB
30TB
50TB
60TB
85TBSlide13
HP Factory Express services for Fast Track
Freeing up IT, getting more
value
!
Without HP Factory Express:
Complexity
Confusion
Slow time to solution
With HP Factory Express:
Faster time to solution
More available IT resources
Maximized IT investmentSlide14
Data sources
The Traditional Data Warehouse
OLTP
ERP
CRM
LOB
BI & analytics
Data warehouse
ETL
Dashboards
Reporting
…data warehousing has reached the most significant tipping point since its inception. The biggest, possibly most elaborate data management system in IT is changing.
–
Gartner, “The State of Data Warehousing in 2012”Slide15
BI & analytics
Data warehouse
ETL
Dashboards
Reporting
The Traditional Data Warehouse
Increasing
data volumes
1
Real-time
data
2
Non-relational data
Devices
Web
Sensors
Social
New data
sources & types
3
Cloud-born data
4
Data sources
OLTP
ERP
CRM
LOBSlide16
Microsoft’s Modern Data Warehouse
BI and analytics
Data enrichment and federated query
Data management and processing
Self-service
Corporate
Collaboration
Mobile
Machine
Learning
Single query model
Extract, transform
, load
Data quality
Master data management
Data sources
OLTP
ERP
CRM
LOB
Box software
Appliances
Cloud
Non-relational data
Devices
Web
Sensors
Social
Box software
Appliances
Cloud
Analytics Platform System
SQL Server
2014
Azure
HDInsight
Azure Machine Learning
Data PlatformSlide17
Moving from SQL
Server to APS
Why?
Distributes data and query processing across multiple servers – eliminates bottlenecks inherent in SMP architecture
Integrated storage is more cost effective over most SAN systems – lowest DW Appliance $$/TB in the industry
Linear scale out to 6 petabytes of usable storage for
DW
Significantly less performance tuning over an SMP
solution
Seamless RDBMS and Hadoop integration with
PolyBase
APS
Compute
Node
Compute
Node
Compute
Node
Compute
Node
Compute
Node
Compute
Node
Management
Node
Control
NodeSlide18
Parallel or not parallel?
SQL Instance
Storage
Scale up (SMP)
Traditional approach
Build for specific requirement
Build HA etc. additionally
Maintain and Tune (Load/File Distribution)
Unknown
Future
workloads
Still a very good data mart solution in a Hub and Spoke architecture with SQL Server PDW
Scale out (MPP)
Modern way of data warehousing
Resilient & Predictable
Big data / DW Best Practices in a box
Deploy Fast and Drive Value
Built-in HA
Scalable (start small/grow when needed)
SQL Instance #2
SQL Instance #1
SQL Instance #4
SQL Instance #3
SQL Instance #8
SQL Instance #....
Storage
Storage
Storage
Storage
Storage
StorageSlide19
Prebuilt & performance-tuned
applianceLinear scale-out
to petabytes of data
MPP design & in-memory columnstore
for 100x speed improvement
Dedicated region
for
Hadoop
Joining relational & non-relational data
with
Polybase
Analytics Platform System
Microsoft’s Big Data Appliance
MPP SQL Server
Hadoop
PolyBaseSlide20
HP’s
rapid data warehouse appliance evolution
Giving
you what
you need … when you need it ..
2011
HP Enterprise Data Warehouse Appliance
1
st
HP/Microsoft DW appliance
2013
HP AppSystem for Microsoft SQL Server 2012 Parallel Data Warehouse
Massive jump in scalability and functionalityUp to 6PB with Hadoop connector
2014
HP ConvergedSystem 300 for Microsoft Analytics Platform
New high-performance, high-availability platformFully integrated Hadoop
Scalability
FunctionalitySlide21
HP ConvergedSystem 300 for Microsoft Analytics Platform
50%
Lower cost per TB
2
100
X
Faster query speed
1
30%
Better scan rate
1
1
Than previous generations
2
Than competitive offerings
Next-generation data warehouse for mission-critical environments
Factory built, appliance-based on HP Converged Infrastructure
Pre-loaded with Microsoft software, integrated, tested, and tuned
Architecture chosen for best data warehouse performance
Single view of information across the enterprise
New addition to the Converged Systems “Sharks” familySlide22
Integrated
, enterprise-ready Apache Hadoop
HDInsight for
consolidated querying
of structured and unstructured
data
Failover Server
Orchestration Server
Orchestration Server
PDW Region
Base Scale Unit
HDInsight
Data Scale Unit
PDW
Data Scale Unit
HDI Region
Base Scale Unit
High performance tuned within the appliance
Leverage existing T-SQL skills
Accessible insights with Microsoft business intelligence tools
Manageable, secured, and highly available
100% Apache HadoopSlide23
A single appliance for rapid time-to-value
HP ConvergedSystem 300 for Microsoft Analytics: What’s in the box?
HP and partner assessment, design, and planning services
3
Priced separately
4
HP Proactive Care. Microsoft support priced and purchased separately
Microsoft Windows® 2012 and
System Center software
HDInsight
(Microsoft’s Hadoop-based distribution)
HP management tools and utilities
HP Converged Infrastructure: servers, storage, and networking
HP
Deployment Accelerator Service (On
site deployment services)
Microsoft Parallel Data Warehouse (PDW) software
3
Collaborative support services from HP and Microsoft
4Slide24
Base Parallel Data Warehouse (PDW) components
HP ConvergedSystem 300 for Microsoft Analytics Platform
InfiniBand (data network) and Ethernet (management network) connectivity
Virtualized control and management node; failover node for high availability (HA)
PDW: Massive parallel
scale-out query processing
PDW Region Base Scale Unit
Orchestration Server
APS Rack & Network
1 x HP 642 Shock Intelligent Series Rack
2 x FDR InfiniBand
2 x HP 5120 switches (2)
2 x power distribution unit
Choice of single-phase or multi-phase
(priced separately)
PDW Region Base Scale Unit (Control)
1 x Orchestration Server (PDW)
1 x Failover Server (PDW)
1 x
Optional
Failover Server (PDW)
PDW Region Base Scale Unit (Processing)
2 x PDW Data Servers
(DL360p)
1 x DAS Storage
Block (DS6000)
1 TB, 2 TB, or 3 TB choice
Failover Server
Failover ServerSlide25
PLUS integrated analysis with Hadoop-based HDInsight
Manage data of any size or type
Relational or non-relational
Perform more complex analysis faster
SQL Server PDW’s PolyBase
One appliance for integrated analysis of HDInsight non-relational and SQL Server PDW relational data
100%
Apache Hadoop-based data platform
Scale quickly and easily
Add up to 3 x
HDI Data Scale
Unit
s and 1 x HDI Failover Server
per rack
HDI Region Base Scale Unit (Control)
1 x Orchestration Server (HDInsight)
1 x Failover Server (HDInsight)
Orchestration Server
PDW Region Base Scale Unit
Orchestration Server
HDI Region
Base Scale Unit
HDI Region Base Scale Unit
(Processing)
2 x HDI Data Servers
1 x DAS Storage Block
1 TB, 2 TB, or 3 TB choiceSlide26
Increase capacity and/or functionality
quickly with minimal downtime
On-premise upgrade options
Orchestration Server
PDW Region
Base Scale Unit
Orchestration Server
HDI
Data Scale Unit
PDW
Data Scale Unit
HDI Region
Base Scale Unit
Failover Server
PDW Region
Base Scale Unit
Orchestration Server
PDW
Data Scale Unit
Additional HA standby server
1 x Optional Failover Server
PDW Data Scale Unit
2 x PDW Data Servers
1 x DAS Storage Block
1 TB, 2 TB, or 3 TB choice
6
HDI Region Base Scale Unit (Control)
1 x Orchestration Server (HDInsight)
1 x Failover Server (HDInsight)
HDI Data Scale Units
7
4 x HDI Data Servers
2 x DAS Storage Blocks
1 TB, 2 TB, or 3 TB choice
6
6
Must match existing capacity drives
7
All HDInsight nodes must be added at the same time
OR
Failover Server
Failover ServerSlide27
Flexible, mix-and-match PDW and HDInsight
From the factory or expandable in the field (examples )
Modular
Flexible
Cost-effective
or
or
PDW Region Base Scale Unit
Orchestration Server
Orchestration Server
HDI Region
Base Scale Unit
PDW
Data Scale Unit
PDW
Data Scale Unit
Orchestration Server
PDW Region Base Scale Unit
Orchestration Server
HDI
Data Scale Unit
PDW
Data Scale Unit
HDI Region Base Scale Unit
Orchestration Server
PDW Region Base Scale Unit
Orchestration Server
HDI
Data Scale Unit
HDI
Data Scale Unit
HDI Region Base Scale Unit
PDW Region Base Scale Unit
Orchestration ServerSlide28
HP ConvergedSystem 300 for Microsoft Analytics
Platform
Massive scalability
Base rack
Fully populated
base rack (8 nodes)
Easily expand by adding racks
Up to 6 PB
5
(PDW Region)
Up to 1.2 PB
(HDInsight Region)
Up to 64 nodes
per workload region
5
Based on 5:1 compressionSlide29
HP ConvergedSystem 300 for Microsoft Analytics Platform
High-availability features for increased uptime
NETWORK REDUNDANCY:
2 x InfiniBand Switches (Data)
2 x Ethernet Switches (Management)
SERVER REDUNDANCY:
All servers participate in an Active/Passive Windows Failover Cluster with the Failover Server.
An Optional Failover Server can be added as a second failover server.
STORAGE REDUNDANCY:
All data is mirrored across electrically separated arrays.
Spare disks are available to rebuild a disk in the event of a failure.
SOFTWARE FAILOVER:
Each management (Orchestration) or processing (PDW and HDI) instance runs within a VM.
Any VM can failover to the Failover Server.
POWER DISTRIBUTION UNIT REDUNDANCY:
2 x Single Phase or Three Phase (choice)
International or NA/JPN option
Securely manage and monitor power distribution from anywhere to prevent problems and speed response times.Slide30
Inside a Scale Unit – Physical View
PDW orchestration
PDW failover
Compute nodes
D6000
Storage 1
Storage 2
Node 1
Node 2
Private Ethernet
network
Dual InfiniBand
SAS
Base scale unit
Control and management functionality
Compute nodes access their local D6000 in their respective scale unitSlide31
Inside a PDW Scale Unit – Fabric View
D6000
Storage 1
Storage 2
Node 1
Node 2
Private Ethernet
network
Dual InfiniBand
SAS
Base scale unit
Control Node
MAD
AD
VMM
Compute Node 1
Compute Node 2
iSCI
01
iSCI
02
PDW orchestration
PDW failoverSlide32
Inside the HDI Scale Unit – Fabric View
D6000
Storage 1
Storage 2
Node 1
Node 2
Private Ethernet
network
Dual InfiniBand
SAS
Base scale unit
HHN
HSN
HMN
Data Node
1
Data Node
2
iSCSI
01
Data Node
3
Data Node
4
iSCSI
02
PDW orchestration
PDW failoverSlide33
Exclusive to HP: HP Support Pack
Simplified management for increased ROI
Unique HP tools ensure solution runs at optimal performance and delivers expected return on investment (ROI)
Validation of Microsoft Reference Architecture (MRA) compliance
Reports all serial numbers and rack locations of all devices
Diagnostic tools to validate configuration
Provide Proactive Care reporting for support
ConvergedSystem firmware/driver update packageSlide34
Prepare your organization and environment
HP Migration Assessment for ConvergedSystem 300 for Microsoft Analytics Platform
HP Advisory Service for ConvergedSystem 300 for Microsoft Analytics Platform
HP Services get you up and running … fast
Accelerated time-to-information-value
*
Included in the price of the appliance order
Smooth migration and speedy deployment
HP Factory Express Integration and Onsite Start-up Services
HP Deployment Accelerator Service for ConvergedSystem 300 for Microsoft Analytics Platform*
HP Migration Service for ConvergedSystem 300 for Microsoft Analytics Platform*
Proactive support and organizational readiness
HP Proactive Care
Personalized Support Option
Proactive Select Credits
HP Education Services
Advise
Migrate & Deploy
OperateSlide35
HP ConvergedSystem 300 for Microsoft Analytics Platform
HP + Microsoft deliver leading price/performance …100x faster
query speed
30% better
scan rate
35% lower acquisition cost
50% lower cost/TB
8
8
valueprism.com/resources/resources/Resources/PDW%20Compete%20Pricing%20FINAL.pdfSlide36
Results: Reporting
80x
Faster
Criteria: 2xSlide37
Results: ETL for Current DatabaseWith limited ETL tuning on 25% packages
3x
Faster
Criteria: 2xSlide38
For more information
Hewlett Packard
HP ConvergedSystem 300 for Microsoft Analytics Platform
hp.com/go/
convergedsystem
/cs300aps
HP ActiveAnswers
hp.com/solutions/activeanswers
MicrosoftMicrosoft
Analytics Platform Servermicrosoft.com/apsSlide39
MS SQL Server 2014 on the HP ProLiant DL580 Gen8Slide40
Unleash the power of your business data with HP ProLiant DL580 Gen8
Breakthrough 4-socket performance and scalability
2.3X performance (60 cores)
1.5X DDR3 memory slots (96 DIMMs)
2.7X IO bandwidth (5 x16 slots)
2X storage performance (12 G SAS)
1.2X internal SSD bays (10 bays)
HP Advanced Error Recovery
HP Memory Quarantine
HP Advanced Fault Resiliency
HP Advanced Event Reporting
Enhanced security
Proactive care support services
Consolidation savings
SW licensing cost savings
Integrated management (HP
OneView)
Intelligent Gen8 (iLO 4) managementHP Smart Update ManagerCustomer-inspired innovations
Leading x86 availability and rock-solid reliability
Compelling efficienciesSlide41
DemoScalability with SQL Server 2014 on the HP ProLiant DL580 Gen8Slide42
Fewer memory and processor based outages
HP Advanced Error Recovery
Recovery from uncorrectable processor, cache and memory errors during execution
1
Uncorrectable error detected in processor, cache or memory under execution pipeline
Firmware informs OS, hypervisor and end-application
OS, hypervisor and end-application initiates recovery action – thread, process, VM, application kill/re-started
System keeps running and prevents crash
2
3
4
Processors
L1 Cache
Core
L2 Cache
Uncore
DRAM
HP Advanced Error Recovery and HP Memory Quarantine require recovery awareness in OS, Hypervisor and End-application
HP
Memory Quarantine
Recovery from uncorrectable memory errors which may cause a system crash
1
MCA Recovery detects uncorrectable memory error
HP Memory quarantine tags memory location as bad and sends address to OS/hypervisor
OS/hypervisor decides how to handle recovery
Os
/hypervisor blocks use of bad memory location
2
3
4Slide43
DemoMemory quarantine with MS SQL Server 2014 on the HP ProLiant DL580 Gen8Slide44
HP Universal Database Solution
High or Tiered performance for SQL Server 2014 Databases
Highly available and future proof
Tier 1 data services and upgradability
Lower total cost of ownership (TCO)
Great price/performance for database consolidation
High OLTP performance at multiple capacities
Million+ OLTP transactions per minute
Highly available and future proof
Tier 1 data services and upgradability
Flexible deployment options
Physical/Virtual NUMA aware topologies
Optimized for multiple concurrent workloads
Powerful and easy to manage resource controls
DL580 Gen8
& 3PAR
7450 All-Flash Edition
High
speed data and transactional processing without compromises
DL580 Gen8
&
3PAR
7400
Edition
Tiered performance designed for multiple workload consolidationSlide45
MS SQL Server 2014 Data Warehouse Fast Track
DL580 Gen8 and HP PCIe LE Workload Accelerator 90 TB Reference ArchitectureHigh performance at low latenciesEliminate the complexity of appropriate sizingReduce unnecessary scale-out
infrastructure
HP ProLiant DL580 Gen8
4 x Intel Xeon E7-4890v2 (2.8GHz/15-core)
1.5 TB DDR3 Memory
2 x 500GB 7200RPM HDD for OS (RAID 1)
Windows Server 2012
R2
© Copyright 2014 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.
HP PCIe LE Workload Accelerator
6 x 5.2TB HP Workload Accelerator PCIe Flash devices for data and tempdb
2 x 1.3TB HP Workload Accelerator PCIe Flash devices for log (RAID 1)Slide46
Thank you for your attention, please visit us on our booth for any question you might have!Slide47
BackupSlide48
Come
visit us
in the Microsoft Solutions Experience (MSE)!
Look for the
Cloud and Datacenter Platform
area
TechExpo
Hall 7
For
more information
Windows Server Technical Preview
http://technet.microsoft.com/library/dn765472.aspx
Windows Server
Microsoft Azure
Microsoft Azure
http://azure.microsoft.com/en-us/
System Center
System Center Technical Preview
http://
technet.microsoft.com/en-us/library/hh546785.aspx
Azure Pack
Azure Pack
http://
www.microsoft.com/en-us/server-cloud/products/
windows-azure-packSlide49
Resources
Learning
Microsoft Certification & Training Resources
www.microsoft.com/learning
Developer Network
http
://developer.microsoft.com
TechNet
Resources for IT Professionals
http://microsoft.com/technet
Sessions on Demand
http://channel9.msdn.com/Events/TechEdSlide50
Please Complete An Evaluation FormYour input is important!
TechEd Schedule Builder
CommNet
station
or PC
TechEd Mobile
app
Phone or Tablet
QR codeSlide51
Evaluate this sessionSlide52
© 2014 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.