1 / 24

HP Enterprise Data Warehouse Appliance

HP Enterprise Data Warehouse Appliance. Optimized for Microsoft SQL Server 2008 R2 Parallel Data Warehouse (PDW). Enterprise data warehouse challenges. Rapid growth of data, both structured and unstructured

devi
Télécharger la présentation

HP Enterprise Data Warehouse Appliance

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. HP Enterprise Data Warehouse Appliance Optimized for Microsoft SQL Server 2008 R2 Parallel Data Warehouse (PDW)

  2. Enterprise data warehouse challenges • Rapid growth of data, both structured and unstructured • Disparate data silos, often scattered across the enterprise, with no single, consistent view of the business • Difficulty aggregating and analyzing data • Complexity of custom solutions and manual processes to extract-transfer-load (ETL) from disparate systems • Costly to implement and operate

  3. Obstacles to successful enterprise data warehouses What customers are saying • Systems complex and inefficient • Solutions costly and slow to deploy • Information hard to access • Volume, variety and velocity of data

  4. ‘There’s money waiting to be extracted from the data’ $10.66 to $1 45% Opportunities

  5. HP and Microsoft solution HP Enterprise Data Warehouse Appliance • Complete data warehouse (DW) solution with integrated tools for extract-transform -load (ETL), business intelligence (BI), mobile device management (MDM) • Massively Parallel Processing (MPP) architecture for enterprise-class scalability and performance • Ability to handle “big data” from all sources (with Apache Hadoop connectors) • Simplified, streamlined deployment • Low total cost of ownership • #1 infrastructure + #1 software company = compelling value

  6. HP EDW + Microsoft PDW Unmatched synergy offering true value to enterprise data warehouse market • HP Enterprise Data Warehouse • Integrated appliance based on HP Converged Infrastructure • Microsoft Parallel Data Warehouse: • Robust business analytics software platform

  7. Value of HP EDW Appliance • Complete • Integrated appliance for mission-critical environments • Half-data and full-data rack configurations • Comprehensive consulting services • Optimized • Single view of information • One-step solution update • Enterprise-class scalability • Market-leading $/TB • Agile • Scalable, easy-to-manage enterprise DW • 20x scale to 600 TB • 40 to 200x faster queries Reduced complexity and deployment expense with industry-leading price/performance and mission-critical support

  8. HP Enterprise Data Warehouse at a glance 50% Better TempDB performance* 1.5x Faster scan rate performance* 25% Greater processor scalability* 25% More storage capacity per rack* * Based on internal HP testing.

  9. HP Enterprise Data Warehouse Database nodes Storage nodes Control nodes Active/passive • Simplified – Choice of deployment options with half-data and full-data rack configurations • Complete – Designed for mission-critical environments • Highly reliable – Leveraging the world-renowned reliability of HP ProLiant Gen8 servers—the most self-sufficient servers in the world Client drivers Management nodes Management Data center monitoring Dual fiber channel Landing zone Landing zone Dual InfiniBand ETL load interface Backup nodes Backup node Corporate backup solution Spare database server Corporate network Private network

  10. Massively Parallel Processing Comparing HP EDW/PDW with traditional symmetric multiprocessing (SMP)

  11. Key benefits: Room for growth: Ability to upgrade architecture by 10x as data grows High performance: Shared nothing architecture allows for maximum performance Appliance by design: HP tools for optimal performance of infrastructure Built-in BI Integration with Microsoft BI tools and connectors for heterogeneous BI environments HP EDW runs Microsoft SQL PDW using MPP Control rack Data racks • ½ to 4 data racks • 11-50 Servers • 22-100 Processors • 152-728 Cores • 30 to 610TB

  12. New with HP EDW 1.4 HP differentiation from the ground up Upgrades ProLiant Gen 8 PDW AU3.5 software

  13. Raw capacity of HP EDW Appliance Note: Full data rack has 11 servers (10 active DB nodes + 1 hot standby node) with capacity starting from 76TB

  14. PDW = a complete business analytic platform

  15. HP Enterprise Data Warehouse components • Control rack • Servers: 2 x HP ProLiant DL360 G7 servers; 1 x HP ProLiant DL370 G6 Server; 3 x HP ProLiant DL380 G7 servers • Storage: HP P2000 G3 (+ internal) storage • Software: Microsoft Windows® Server 2008 SP2; Microsoft S QL Server 2008 R2 Parallel Data Warehouse • Infrastructure: InfiniBand, Fiber Channel, Ethernet switching, 42U rack Data rack (choice of full or half*) • Servers: 10 active + 1 passive HP ProLiant DL360 G7 Server compute node (half* 4 + 1) • Storage: 10 x HP P2000 G3 (half* 4) • Software: Microsoft Windows Server 2008 SP2; Microsoft SQL Server 2008 R2 Parallel Data Warehouse • Infrastructure: InfiniBand, Fiber Channel. and Ethernet switching, 42U rack • Expansion • Start with one half-data or one full-data rack and easily expand by adding data racks (up to a maximum of four racks). Services • Industry-leading reactive and mission-critical support jointly delivered by HP and Microsoft; providing integrated, end-to-end coverage of hardware and software components

  16. Engineering process and testing to develop HP Enterprise Data Warehouse Months of preparation and hundreds of pre-configurations Developed an optimal configuration for data warehousing up to 610 TB Tested and pushed performance for configurations Defined the target workloads

  17. “Having launched as America’s newest stock exchange and rapidly grown our market share, we needed to address our outgrown data marts and improve storage access for analysis and reports. Our expectations for setup, ease of management and processing speed were exceeded at every point by HP and Microsoft with the fully integrated preconfigured HP Enterprise Warehouse appliance. With the combined expertise of HP, Microsoft, and BI Voyage, we have tested the solution to generate reports in under 15 minutes for what used to take over four hours.” Rich Hochron Chief Technology Officer of Direct Edge

  18. Services for HP Enterprise Data Warehouse Assessment Standard Services Start Service • Existing process review • Optimize for EDW: ETL, reporting • Integration needs assessment • Two-week duration • Installation • Set up • Delivery project management • ETL readiness and test • Reporting, migration, testing • Performance tune and test • Data center integration • Operations review • Two-week duration Full lifecycle of Data Warehouse/Business Intelligence consulting

  19. HP BI/Data Warehouse Consulting Complete service portfolio Data Warehouse Consulting Business consulting Data quality Master Data Management Information governance DW design, ITL design, implementation SQL Infrastructure Consulting Performance tuning Oracle to SQL migration SQL consolidation Start Service for Enterprise Data Warehouse Appliance Data Warehouse Assessment EDW Solution Implementation Business Decision Appliance One-week service produces actionable business intelligence Deployment/training/pilot

  20. HP Enterprise Data Warehouse support HP and Microsoft collaborative support Microsoft and HP work together to provide a seamless support experience. Choose the service levels to meet your business needs. Recommended Microsoft HP Support Plus 24 • Reactive 24x7 hardware and software support for HP appliance components • Four-hour onsite hardware response Premier Support * • 24x7 Reactive Support with on-site response • Proactive Services • Technical Account Management or or upgrade through add-on Proactive 24 Service • Integrated hardware and software support including proactive and reactive services to improve stability and availability across your IT environment Premier Mission Critical • All features of underlying Premier Support Plan plus • Faster reactive response time with on-site solution engineering support • Prioritized access to Microsoft product groups • Solution supportability review and architectural guidance for maximum performance or Critical Service • Comprehensive support solution designed to help minimize the business impact of downtime for mission-critical applications * Premier Support plan (Standard level or above) is a prerequisite for PDW customers

  21. How to buy HP Enterprise Data Warehouse HP hp.com/solutions/microsoft/edw Microsoft microsoft.com/sqlserver/en/us/solutions-technologies/appliances/hp-pdw.aspx Additional information <Presenter contact information for follow up>

  22. Take the next step today Assess where you stand See it in action Optimize for your environment SQL Optimization Consulting Services • HP Data Management Assessment Services • Assessment and Business Discovery Services • Architectural Design Workshop and Data Migration Assessment • Pilot • HP AppSystems demos • Live at HP and Microsoft Solution Centers • Virtually on-demand at your location

  23. Take the HP and Microsoft challenge, see the compelling benefits: HP and Microsoft demo/POC units around the world Thames Valley, London Beijing, China Seoul, South Korea Chicago, U.S. Boeblingen, Germany  Washington, U.S. Tokyo, Japan New York, U.S. Amsterdam, Netherlands Sao Paulo, Brazil

  24. Thank you

More Related