Cisco-EMC SQL Server Data Warehouse Fast Track Solutions - PowerPoint PPT Presentation

slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Cisco-EMC SQL Server Data Warehouse Fast Track Solutions PowerPoint Presentation
Download Presentation
Cisco-EMC SQL Server Data Warehouse Fast Track Solutions

play fullscreen
1 / 57
Cisco-EMC SQL Server Data Warehouse Fast Track Solutions
189 Views
Download Presentation
betrys
Download Presentation

Cisco-EMC SQL Server Data Warehouse Fast Track Solutions

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Cisco-EMC SQL Server Data Warehouse Fast Track Solutions Sales Training October 17, 2011 TxominBarturen, EMC Eyal Sharon, EMC Justin Kennedy, EMC Frank Cicalese, Cisco Charley Schaff, Cisco Theresa Chen, Cisco

  2. Agenda • Joint sales opportunity • Customer environment and challenges • SQL Server Fast Track Data Warehouse program • EMC and Cisco joint offering • Value proposition and differentiation • Identifying opportunities • Engagement model and sales contacts • Ordering and fulfillment • Competition • Call to action

  3. Joint Sales Opportunity • Microsoft data warehousing = huge sales opportunity • $2.1B addressable market for Cisco UCS • $2.6B storage opportunity * - most of this is EMC VNX opportunity • Microsoft SQL Server is a big player in data warehousing and they are investing to grow share • EMC-Cisco have developed Fast Track Solutions to … • Help you identify new DW opportunities and win in this large market • Simplify customer deployment with pre-tested, validated solutions • Help start new sales conversations with Cisco, EMC and Microsoft * IDC, 2011

  4. What is a Data Warehouse? A Data Warehouse organizes historical data from multiple sources into functional areas - such as accounting, manufacturing and HR - enabling key lines of business and executives to make decisions Business Value Delivers timely and trustworthy intelligence on a variety of business activities and processes to help executives make better decisions

  5. Data Warehouse Customer Challenges Approximate data volume managed by data warehouse • Increased data volumes • Need to reduce costs • Increased adoption of DW appliances • Demand for flexibility and mixed workloads • Desire for real-time analytics • Growing importance of data quality Today In 3 Years 21% Less than 500 GB 5% 20% 500 GB – 1 TB 12% 21% 1 – 3 TB 18% 19% 3 – 10 TB 25% 17% More than 10 TB 34% 2% Don’t Know 6% Source: TDWI Report – Next Generation DW

  6. Data Warehouse Customer Challenges • Increased data volumes • Need to reduce costs • Increased adoption of DW appliances • Demand for flexibility and mixed workloads • Desire for real-time analytics • Growing importance of data quality Effect of current recession on DW teams and projects Budget reduced 57% Hiring frozen 41% Approved projects on hold 30% Priorities shift to short-term gains 31% No impact so far 27% New tool and platform acquisitions frozen 25% Some team members laid off 19% Focus shifted from new dev to admin of old solutions 18% Other 3% Source: TDWI Report – Next Generation DW

  7. SQL Server Fast Track Data Warehouse Reference Architectures to help customers accelerate their DW deployments • A method for designing a cost-effective, balanced system for Data Warehouse workloads • Reference configurations developed in conjunction with hardware partners • Best practices for data layout, loading and management

  8. EMC-Cisco SQL Server Fast Track Joint Offerings Reference Architectures to help customers accelerate their DW deployments • Mid Size Enterprise Fast Track Configuration • Target Data Warehouse size: 12 – 24 TB • Solution components: • - Cisco UCS C250 M2 Rack Mount Server (2 processors) • - EMC VNX 5300 Storage System with 75 SAS disk drives • Large Enterprise Fast Track Configuration • Target Data Warehouse size: 24 – 48 TB • Solution components: • - Cisco UCS C460 M1 Rack Mount Server (4 processors) • - Two EMC VNX 5300 Storage Systems (each with 75 SAS disk drives) • Upsell Cisco networking, EMC BRS products and DR

  9. Value proposition Reduced Risk Accelerated Time to Value • Validated by Microsoft, Cisco and EMC; reduces risk of overspending • Cisco UCS integrates compute, storage, network for balanced performance • Known performance and scalability • Reduced design, deployment time • Cisco UCS automates configuration and provisioning of server, network, storage Low TCO High Scale and Performance • Pre-tested and validated configuration • Shorter deployment through Cisco UCS integration of compute, storage, network • VNX high density footprint and price-performance value • Proven scalability to 48TB • Best of breed - UCS ideal for large memory-intensive workloads • High-bandwidth EMC VNX ideal for DW

  10. High memory density = more workspace in a single server for data warehouse workloads Integration of compute, storage, and network = simplified deployment and management Automated server configuration process = faster time to benefit Unified network fabric converging LAN and SAN = fewer interface cards, cables, and switches Fewer cables, interface cards, physical servers = lower energy costs and less floor space Cisco UCS – DW Value Proposition

  11. VNX Hardware – Ideal for DW Environments • High density drive shelves and racks • Shelves: 25 Drives, 2U Where floor space is a premium VNX is footprint efficient • High bandwidth (Coming this quarter!) • Adds an additional 6Gb/s four lane SAS Ideal for Data warehousing/BI 3X THE CAPACITY 2X THE BANDWIDTH

  12. Target Customer Contacts and Challenges • Infrastructure teams • Challenges • No time to plan – reacting to data and user growth • Implementation issues – delayed or expensive DW projects • Performance issues and difficulty with root causes • Data center constraints – floor space, power and cooling • Business service levels difficult to meet Business Decision-Makers Challenges • Executives need better information to make business decisions • Data needs to be accurate and up-to-date • Demand for analytics to assess new business opportunities is escalating • BI projects can be expensive and risky • BI applications are often hard to implement and use

  13. Questions for Business Decision Makers

  14. Questions for Technical Decision Makers

  15. Sales Engagement • Contact your sales counterpart from EMC or Cisco to prospect for data warehouse opportunities in your account • Engage specialist resources from EMC or Cisco to help qualify opportunities • Leverage joint EMC and Cisco channel partners for solution fulfillment • Microsoft sales contacts available to support engagement as needed

  16. Sales and Technical Contacts Cisco EMC • Email the contacts above with the following: • Details on the help needed • Details on the specific opportunity • What region/territory are you located in

  17. Microsoft Sales Contacts Microsoft Fast Track Data Warehouse Contacts Engage your Cisco and EMC contacts for help engaging with Microsoft in your account

  18. Targeted Fulfillment Partners All the above are Cisco, EMC, and Microsoft Gold partners * Microsoft LAR’s

  19. Competitors The companies below have also published SQL Server Fast Track Data Warehouse solutions. Some of these competitors offer compute, storage, and network under the same label.

  20. Competition and Response

  21. Call to Action • Read available sales and technical content to learn more about the solution • Identify contacts within your account for a data warehouse conversation • Listen for pain points, competitive POCs, major issues • Engage your local EMC and Cisco sales teams and technical contacts to discuss opportunities • Leverage supporting sales and technical resources to help qualify the opportunity • Develop account plans based on identified opportunities

  22. More Information • EMC • SQL Fast Track Data Warehouse Datasheet on PowerLink: • Home > Solutions > Application Solutions > Microsoft > SQL Server > Core Information > Data Sheets • Fast Track Technical Whitepaper on PowerLink: • Home > Solutions > Application Solutions > Microsoft > SQL Server > Core Information > White Papers • Cisco • SQL Fast Track Data Warehouse Datasheet and Configuration Guide are available at • www.cisco.com/go/microsoft. Click on Solutions tab.

  23. Q & A

  24. Cisco-EMC SQL Server Data Warehouse Fast Track Solutions Technical Training October 17, 2011 Frank Cicalese, Cisco Txomin Barturen, EMC

  25. Microsoft SQL Server is not just a relational database. It is a comprehensive, integrated data platform which contains a complete set of tools that help people derive value from information. What is Microsoft SQL Server?

  26. SQL Server 2008 R2 Core Editions Comparison

  27. SQL Server Integration Services:Architecture

  28. SQL Server Analysis Services:Architecture

  29. SQL Server Reporting Services: Architecture Report Server RS Scale Out Deployment Report Catalog Reporting Data

  30. Business IntelligenceElements of the process Clients Data Marts and cubes Source Systems SQL ServerData Warehouse Query Tools Reporting Analysis Data Mining 2 1 3 4 Design the PopulateCreateQuery Data Warehouse Data WarehouseOLAP CubesData

  31. Business IntelligenceElements of the process Clients Data Marts and cubes Source Systems SQL ServerData Warehouse Query Tools Reporting Analysis Data Mining 2 1 3 4 Design the Populate CreateQuery Data Warehouse Data Warehouse OLAP CubesData

  32. Business IntelligenceElements of the process Clients Data Marts and cubes Source Systems SQL ServerData Warehouse Query Tools Reporting Analysis Data Mining 2 1 3 4 Design the Populate Create Query Data Warehouse Data Warehouse OLAP Cubes Data

  33. Business IntelligenceElements of the process Clients Data Marts and cubes Source Systems SQL ServerData Warehouse Query Tools Reporting Analysis Data Mining 1 4 2 3 Design the Populate Create Query Data Warehouse Data Warehouse OLAP Cubes Data

  34. Data Warehouse versus OLTP • Database Goal • - Designed for analyticaloperations • Strategic focus • - Optimized for bulk load and large, complex, unpredictable queries • - Fewer concurrent users relative to OLTP • Database Goal • - Designed for operationalrequirements • Tactical focus • - Optimized for transactions: “single row” entry and retrieval • - Thousands of concurrent users

  35. Data Warehouse versus OLTP • Storage Goal • - Primary focus on sequential read operations • - Optimized for disk scan over seek operations • - Storage optimization focused on disk scan rate (MB/s) • Storage Goal • - Emphasis on transactional (random) performance • - Optimized for disk seek over scan operations • - Storage optimization focused on I/O operations/s (IOPs)

  36. Customer Data Warehouses Challenges • Attempt to utilize pre-existing environment • *ADD* Data Warehouse work onto existing production infrastructure • Resource intensive for customer to design configuration • Low success factor and poor ROI

  37. Customer Challenge • Server/Storage design balance can be complex for customers to design … and get right! • - Server can consume 12 GB/sec of IO, but the SAN can only deliver 2 GB/sec • Even when the SAN is dedicated to the SQL Data Warehouse, which it often isn’t • - SAN can deliver 16 GB/sec, but the server can only process 2 Gb/sec • Queries are slow • - Despite significant investment in both Server and Storage Result: significant investment, not delivering performance

  38. Fast Track Solution: Balanced System Design • Design a server /connectivity/storage configuration that optimizes storage I/O capability with SQL Server data processing capacity • Avoid the performance challenge of shared systems • Avoid over-investment in disk drives by optimizing storage for workload attributes and server I/O consumption capability • Allow customer personnel to focus on primary role • - Not designing a server/storage configuration

  39. SQL Server 2008 R2 Fast Track Data Warehouse 3.0 A Cisco/EMC Validated Architecture and Reference Configuration Improve Performance, Lower Data Center Complexity and Deliver Unified Management • Fastest time to market for your data warehouse solution • Out-of-the-box performance • Mitigate risk • Two configuration to choose from. • Scale from 12 up to 48 terabytes • Based on Cisco UCS C-Series rack-mount servers • Designed to operate in both standalone environments and as part of Cisco Unified Computing System • Powered by EMC VNX Series, achieve new levels of performance, protection, compliance, and ease of management UCS Server Family Designed, Tested and Validated for Performance and Cost

  40. What is SQL Server Fast Track Data Warehouse? • A Solutionto help customers and partners accelerate their data warehouse deployments • A Methodfor designing a cost-effective, balanced system for Data Warehouse workloads • Reference hardware Configurationsdeveloped in conjunction with hardware partners using this method • Best practices for data layout, loading and management

  41. Evolution of Microsoft SQL Server Fast Track Data Warehouse Solutions • Cisco/EMC produced medium and large solution with UCS and VNX 5300 • 12 – 24 TB solution • 24 – 48TB solution V.420xx V.32010 V.22009 • EMC produced two configurations with EMC CLARiiON AX-4 storage system design • 4 – 8 TB solution • 12 – 24 TB solution Cisco/EMC plan additional solutions

  42. SQL Server Fast Track Data WarehouseIt’s all about optimized high performance • SQL Server Fast Track targets traditional data warehousing scenario • Large scans, large fact tables • Writes for history, not operations • Minimal change overtime • SQL Server Fast Track provides high levels of I/O throughput • - Scan intensive, disk scan performance as the key priority • - No indexes and storing data sequentially will provide the fastest disk throughput rates • - Index-lite (few indexes or even no index) is faster because there is less disk head movement

  43. SQL Server Component Architecture Server Storage Interconnect Storage Enclosure Storage Processor Disk Drives Windows Server OS SQL Server Host Storage Adaptor SQL Fast Track covers this

  44. Performance/Sizing Expectations

  45. EMC/Cisco SQL Server Fast Track Data Warehouse 3.0 Reference Configurations • Mid Size Enterprise Configuration : 12 – 24 TB • - Cisco UCS C250 M2 Rack Mount Server • Two Intel Xeon processors X5680 series • 192 GB Memory • - EMC VNX 5300 Storage System • 75 x 300 GB 10K rpm SAS disk drives • Large Enterprise Configuration : 24 – 48 TB • - Cisco UCS C460 M1 Rack Mount Server • Four Intel Xeon processors X7560 series • 256 GB memory • - Two EMC VNX 5300 Storage Systems • Each with 75 x 300 GB 10L rpm SAS disk drives

  46. Cisco/EMC SQL Server FTDW 3.0 Medium Configuration Detail • Physical Configuration • - Server: Cisco UCS C250 M2 Server • Processor : Intel Xeon Processor X5680 (3.33 GHz, 12 MB cache) • Memory: 96 GB (12*8GB DDR3 ) • Internal Disk Drives: 2 x 300 GB SAS disk drives • - Storage: EMC VNX 5300 • Disk drives: 75 x 300 GB 10K rpm SAS disk drives • Data layout: RAID 5 for data files and RAID 10 for log file • - Connectivity • Switch: Cisco Nexus 5548P Switch • Protocol: FCoE • Controllers: 2 x Cisco UCS P81E Virtual Interface card 10Gbps

  47. EMC/Cisco Medium Configuration • indent • Second indent • Third indent • Fourth indent

  48. EMC/Cisco SQL Server - Storage Design

  49. Cisco/EMC SQL Server FTDW 3.0 Large Configuration Detail • Physical configuration • - Server: Cisco UCS C460 M1 Server • Processor : 4 Intel Xeon Processor X7560 (2.26 GHz, 24 MB cache) • Memory: 256 GB (32*8GB DDR3 ) • Internal Disk Drives: 2 * 300 GB SAS disk drives • - Storage: Two EMC VNX 5300 • Disk drives: 150 *300 GB 10 K rpm SAS disk drives (75 each VNX 5300) • Data layout: RAID 5 for data files and RAID 1/0 for log file • - Connectivity • Switch: Cisco Nexus 5548P Switch • Protocol: FCoE • Controllers: 8x QLE8152 dual-port 10Gbps CNA