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

Loading in 2 Seconds...

play fullscreen
1 / 57

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


  • 173 Views
  • Uploaded on

Cisco-EMC SQL Server Data Warehouse Fast Track Solutions. Sales Training October 17, 2011. Txomin Barturen , EMC Eyal Sharon, EMC Justin Kennedy, EMC. Frank Cicalese, Cisco Charley Schaff, Cisco Theresa Chen, Cisco. Agenda. Joint sales opportunity Customer environment and challenges

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Cisco-EMC SQL Server Data Warehouse Fast Track Solutions' - betrys


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


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

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

agenda
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
joint sales opportunity
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

what is a data warehouse
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

data warehouse customer challenges
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

data warehouse customer challenges1
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

sql server fast track data warehouse
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
emc cisco sql server fast track joint offerings
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
value proposition
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
cisco ucs dw value proposition
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
vnx hardware ideal for dw environments
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

target customer contacts and challenges
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
sales engagement
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
sales and technical contacts
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
microsoft sales contacts
Microsoft Sales Contacts

Microsoft Fast Track Data Warehouse Contacts

Engage your Cisco and EMC contacts for help engaging with Microsoft in your account

targeted fulfillment partners
Targeted Fulfillment Partners

All the above are Cisco, EMC, and Microsoft Gold partners

* Microsoft LAR’s

competitors
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.

call to action
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
more information
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.
slide24

Cisco-EMC

SQL Server Data Warehouse Fast Track Solutions

Technical Training

October 17, 2011

Frank Cicalese, Cisco

Txomin Barturen, EMC

what is microsoft sql server

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?
slide30

SQL Server Reporting Services: Architecture

Report Server

RS Scale Out Deployment

Report Catalog

Reporting Data

slide31

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

slide32

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

slide33

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

slide34

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

data warehouse versus oltp
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
data warehouse versus oltp1
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)
customer data warehouses c hallenges
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
customer challenge
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

fast track solution balanced system design
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
sql server 2008 r2 fast track data warehouse 3 0
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

what is sql server fast track data warehouse
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
evolution of microsoft sql server fast track data warehouse solutions
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

sql server fast track data warehouse it s all about optimized high performance
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
sql server component architecture
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

emc cisco sql server fast track data warehouse 3 0 reference configurations
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
cisco emc sql server ftdw 3 0 medium configuration detail
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
emc cisco medium c onfiguration
EMC/Cisco Medium Configuration
  • indent
    • Second indent
      • Third indent
        • Fourth indent
cisco emc sql server ftdw 3 0 large configuration detail
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
take the risk out of getting started cisco emc reference configurations for microsoft sql server
Take the Risk Out of Getting StartedCisco-EMC Reference Configurations for Microsoft SQL Server
  • Fastest time to market for your SQL Server solutions
    • - Predefined system and reference configurations
    • - Joint testing at scale
    • - Mitigates risk
  • Out-of-the-box experience
    • - Reduce hardware testing and tuning
  • Scalable solution
    • - Scales from Small to Medium to Large
    • - Integrated ease of management – standalone and as part of UCS Mgmt
    • - Powered by Cisco UCS Rack-mount Server and EMC VNX Series
  • Lower cost of ownership
    • - Better price performance, rapid deployment and industry-standard hardware
more information1
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.