leverage sandisk flash to optimize sql server performance and redirect customer spend to services

c

Peter PlamondonDirector, Strategic Partner [email protected]

Leverage SanDisk Flash to Optimize SQL Server PerformanceandRedirect Customer Spend to Services

7/14/2015

Forward-Looking StatementsDuring our meeting today we will make forward-looking statements.

Any statement that refers to expectations, projections or other characterizations of future events or circumstances is a forward-looking statement, including those relating to industry trends, products and their anticipated availability, capacities, pricing, capabilities, performance and compatibility, cost savings and other benefits to customers. This presentation also contains forward-looking statements attributed to third parties, which reflect their projections as of the date of issuance.

Actual results may differ materially from those expressed in these forward-looking statements due to a number of risks and uncertainties, including the factors detailed under the caption “Risk Factors” and elsewhere in the documents we file from time to time with the SEC, including our annual and quarterly reports.

We undertake no obligation to update these forward-looking statements, which speak only as of the date hereof or as of the date of issuance by a third party, as the case may be.

2

Agenda & Takeaways

3

Agenda

1. Our Business- Vertical: From our Fabs to your Data Centers- Horizontal: Product Portfolio

2. SQL Server Architectural Solutions Overview

3. Economics: Redirect Customer Spend to Services

4

4

Key Takeaway: SanDisk® Flash is Transformative

1. Depth and breadth of product portfolio

2. Performance: devices capable of delivering• Millions of IOPS • GBs of throughput• µsec latencies

3. Economics: reduced spend to deliver storage performance• Redirect customer budget to additional services

5

5

A Global Leader in Flash Storage Solutions

* Financials as of Q1’15. Net Cash = (Cash + cash equivalents + short-term and long-term marketable securities) less (debt at maturity value) as of end of Q1’15; patents are as of Q1’15.

All Leading Smartphone

& Tablet Manufacturers use SanDisk

SanDisk Supplies Client & Retail SSDs to All Leading PC Manufacturers

Financial Strength*Trailing 4 Quarter Financials*• $6.4B Revenue• 67% Commercial; 33% Retail• $1.9B Net Cash• $0.9B R&D Investment

SanDisk Ventures $75 Million for Strategic Investments

Vertically IntegratedDesign -- Development -- Manufacturing – Applications in the Marketplace

Patent Power• 5,000+ Patents• Thomson Reuters Top 100

Global Innovator(4th consecutive year)

6

Broad portfolio of Microsoft SQL ServerSolutions with OEM partners

What Does It Mean to Have Our Own Fab?

Consistency in standards throughout the production process Economies of scale Savings passed on to you

– Example, 4x price/performance improvement* from Fusion ioDrive2 to new SX350 PCIe flash

7* Source: http://www.sandisk.com/about-sandisk/press-room/press-releases/2015/sandisk-introduces-next-generation-of-fusion-iomemory-pcie-application-accelerators-for-boosting-data-center-performance/

1990 1995 2000 2005 2010 2015

Mega Trend: Legacy Storage I/O Bottleneck

WideningPerformance Gap

Server CPU PerformanceAligning Performance

SSD Performance

HDD Performance

Source: StorageIOblog, Sep 2009; http://storageioblog.com/data-center-io-bottlenecks-performance-issues-and-impacts/

8

SanDisk Enterprise PortfolioPerformance

CostTCA/TCO

Capacity$/GB

(Bandwidth, IOPS, Latency)

9

SanDisk Enterprise PortfolioPerformance

CostTCA/TCO

Capacity$/GB

(Bandwidth, IOPS, Latency) Availability

ZetaScale™ Software

FlashSoft® Software

Storage

Server

SanDisk ION Accelerator™

10

Fusion ioMemory™ SX350Fusion ioMemory™ PX600

Leading the Industry: New! Improved! Gen 3.5

Capacities up to 6.4TBIndustry leading reliabilityStrongest ECC using LDPC

Unprecedented performance

NEW!

Fusion ioMemory™Blade Mezzanine Cards

Capacities up to 1.6TBFrom Cisco and HP

NEW!

11

Customer Testimonial: PlentyOfFish

At any given time, we can have over 700,000 users active, 30,000 messages a minute, 500,000 SQL statements per second across 30 servers.

The ROI is ridiculous. These cards pay for themselves in two weeks.

Owen Morley Director of Infrastructure

PlentyOfFishhttps://youtu.be/zIWgmWEsvpM (2:13)

12

SanDisk Performance and Business Value

Revenue Service more customers faster More customer interaction Faster actionable data

Cost Consolidated infrastructure Higher employee productivity Leverage SAN Investment

Quality Meet SLAs Service customers more quickly

Performance Improvements Business Benefits

Source: 2014 Fusion-io Customer Survey

14%

32%

23%

29% 10x+

6-9x

3-5x

1-2x

13

SanDisk Flash Accelerates SQL Server 2014 OLTP

Microsoft SQL Server 2014

Compared to HDDs:

11x better at write latency

4x total number of transactions

Source: http://www.sandisk.com/assets/white-papers/improve_business_with_sql2014_dell_wp.pdf

SQL Server 2014 In-Memory OLTPTransactions/sec

Fusion ioMemory™ ioDrive2® 2.4TB vs.Enterprise-Class Disk Array

SQL Server 2014 In-Memory OLTPTransaction Log Write Latency (microseconds)

Fusion ioMemory™ ioDrive2® 2.4TB vs.Enterprise-Class Disk Array

Fusio

n ioM

emory

Enter

prise-C

lass Disk

Array

0

500

1000

1500

Fusio

n ioM

emory

Enter

prise-C

lass Disk

Array

0

20000

40000

60000

14

Entire database on in-server Flash

Parts of database on in-server Flash

(e.g., “hot files” or tempdb)

Cache data read from SAN on in-server Flash

AlwaysOn high availability fail-over

FlashSoft

Virtualized database serversfor mixed workloads

Fast Track Data Warehouse Reference Architectures (FTDWRA)

SQL Server 2014 Architectural Configurations

15

HP 28TB Data Warehouse Fast Track CertificationDWFT Certification

#2014-003 HP ProLiant DL380 Gen8 with HP PCIe LE Workload

Accelerator 28TB reference architecture for Microsoft SQL Server 2014 Data Warehouse Fast Track

Report Date 9/3/2014

DWFT Rev. 5.4

System Provider System Name Processor Type Memory

HP DL380 G8 Intel Xeon E5-2697v2 2.7 GHz (12/24/48)

768 GB

Operating System SQL Server Edition

Windows Server 2012 R2 SQL Server 2014 Enterprise Edition

Storage Provider Storage Information

4 x 2.6TB HP PCIe LE Workload Accelerator for data and tempdb 2 x 300GB HDD for OS (RAID 1)

8 x 15K 300GB HDD for log (RAID 10)

Primary Metrics

Rated User Data Capacity1

(TB) Row Store Relative

Throughput2 Column Store Relative

Throughput3 Maximum User Data Capacity

(TB)

28 170 218 32

Row Store

Relative Throughput2

Measured Throughput

(Queries/Hr/TB)

Measured Scan Rate Physical

(MB/Sec)

Measured Scan Rate Logical

(MB/Sec)

Measured I/O Throughput

(MB/Sec)

Measured CPU (Avg.)

(%)

170 202 4,508 5,500 5,004 96

Column Store


Measured Throughput

(Queries/Hr/TB)


(MB/Sec)


(MB/Sec)


(MB/Sec)

Measured CPU (Avg.)

(%)

218 1,414 1,389 N/A N/A 98

Breakthrough Performance - 5.5GB/s throughput - 1414 queries / Hr / TB - 98% average CPU utilization

SanDisk-based 2.6TB HP Workload Accelerators

HP DL380 Server

16





DWFT Rev. 5.4


HP DL380 G8 Intel Xeon E5-2697v2 2.7 GHz (12/24/48)

768 GB




4 x 5.2TB HP PCIe LE Workload Accelerator for data and tempdb 2 x 300GB HDD for OS (RAID 1)

8 x 15K 300GB HDD for log (RAID 10)

Primary Metrics





(TB)

45 161 227 72

Row Store


Measured Throughput

(Queries/Hr/TB)


(MB/Sec)


(MB/Sec)


(MB/Sec)

Measured CPU (Avg.)

(%)

161 198 4,220 5,240 4,730 97

Column Store


Measured Throughput

(Queries/Hr/TB)


(MB/Sec)


(MB/Sec)


(MB/Sec)

Measured CPU (Avg.)

(%)

227 1,476 1,443 N/A N/A 99

Breakthrough Performance - 5.2GB/s throughput - 1476 queries / Hr / TB - 45TB compressed data in 2U

HP DL380 Server


17





DWFT Rev. 5.4


HP DL580 G8 Intel Xeon E7-4890 v2

2.8 GHz (4/60/120) 1536 GB




6 x 5.2TB HP Workload Accelerator PCIe Flash devices for data and tempdb 2 x 500GB 7200RPM HDD for OS (RAID 1)

2 x 1.3TB HP Workload Accelerator PCIe Flash devices for log (RAID 1)

Primary Metrics





(TB)

90 314 419 108

Row Store


Measured Throughput

(Queries/Hr/TB)


(MB/Sec)


(MB/Sec)


(MB/Sec)

Measured CPU (Avg.)

(%)

314 366 8,351 10,139 9,245 92

Column Store


Measured Throughput

(Queries/Hr/TB)


(MB/Sec)


(MB/Sec)


(MB/Sec)

Measured CPU (Avg.)

(%)

419 2,721 3,392 N/A N/A 96

Breakthrough Performance - 10.1GB/s throughput - 2721 queries / Hr / TB - 90TB compressed data in 4U

HP DL580 Server


18

InfiniFlash™ System Workload Targets:

– Content– Analytics– Media Streaming

Performant: – Up to 1,000,000 IOPS – 1 µs latency

Capacity: ½ Petabyte Dense: 3U Flexible: 8 SAS Connectors Hyper-Scaleout Internally Redundant Built-in Monitoring & Alerting Hot-Swappable Storage & Components Learn more:

http://bigdataflash.sandisk.com/infiniflash 19

http://bigdataflash.sandisk.com/infiniflash



Redirect Customer Spend to Services

SanDisk flash economics are disruptive– not transformative merely due to performance

Cost saving scenarios enabled by SanDisk flash1. Using flash to eliminate AlwaysOn read-only secondary and its licenses

2. Application-level: scaling up to big money

3. Data Center scale: saving millions

20

#1. AlwaysOn Readable Secondaries 3 Sustained Simultaneous Workstreams Scenario

– Highly transactional TPCC-like environment – 1,000,000 New Orders per Minute– 4 AlwaysOn AGs in synchronous availability mode, no queuing – Database backups at 4GB/s– I/O Latency: < 0.0ms, i.e., µs range

Recommended Configuration– Readable Secondary used for backup stream– This requires licensing all cores on both servers

Configuration on Fusion ioMemory flash– Backup run from Primary, Secondary used only for failover– This requires only one server be licensed

SQL Server License Savings:– 32 EE licenses (64 cores)

• @$13,473.00 USD = $ 431,136 (non-SA)• @$20,209.00 USD = $ 646,688 (SA) Source: http://www.fusionio.com/blog/having-your-cake-and-eating-it-affordable-performance-with-hp-and-fusion-io-atomic-series

21

THE CHALLENGE• Reduce power, cooling, and footprint• Near real time reporting for 15,000

users running up to 1.2 million queries per month

• Meet failover requirements

RESULTS• 3x more concurrent users• 3x more queries• 2x greater workload• Eliminated maintenance overhead for 27

disk arrays and over 400 disks• 16:1 footprint consolidation• 1/16th power and cooling

USAF Financial Data WarehouseTEKSOUTH

Source: Case Study - TekSouth Fights US Air Force Datacenter Sprawl with ioMemory; http://www.sandisk.com/assets/case-studies/teksouth_cs_dell.pdf

#2. US Air Force & TekSouth

22

“A single server with ioMemory doubled the workload capability of

a 3-server, 21-disk array-based system”

Mike Rhodes

VP of Operations

v

Source: Case Study - TekSouth Fights US Air Force Datacenter Sprawl with ioMemory; http://www.sandisk.com/assets/case-studies/teksouth_cs_dell.pdf

#2. US Air Force & TekSouth

23

#3. Consolidate 1,500 servers to 150 servers Scenario

– Windows Server 2003 & SQL Server 2005 EOL approaching– SAN-attached – Core SQL Server EE licenses @$13,472.50 each– 1,500 servers

Solution– Windows Server 2012 R2 leveraging Hyper-V– SQL Server 2014 leveraging AlwaysOn– Fusion ioMemory PCIe cards from SanDisk– 150 servers – 10:1 consolidation– Hundreds of fewer servers– Thousands of fewer licenses– Millions of fewer dollars– ...with lots of compute and storage headroom– And leftover SANs, shelves and networking

24

Takeaways Challenges:

– How to handle millions of IOPS/device, GBs of I/O throughput, µsec latency– What to do with the leftover spinning media– What to do with the leftover budget?

These scenarios aren’t unusual– They’re typical, and becoming more and more common

You can help customers save hundreds of thousands of dollars

Freeing committed budget for additional services!25

Find Out More!Talk with our experts in Booth 900 – Four Solution Demos:

*Flash-Optimized SQL Server 2014 OLTP Solutions to Accelerate Transactional Performance

*Flash-Optimized SQL Server Data Warehouse Microsoft Validated Solutions for Faster Analytics

*Flash-Optimized Caching with FlashSoft Scale-up Performance for Workload Consolidation

*Flash-Optimized Virtual Infrastructure Solutions to Increase VM Performance and Scale

26

SanDisk Enterprise Reseller Partner Program CloudSpeed™ SATA SSDs, Optimus® SAS SSDs, FlashSoft® caching software, Fusion ioMemory PCIe application accelerators, and more!

Call to Action

Join us at Booth 900

Check out our demo stations and theatre sessions—all day, all week

Contact us at SanDisk Enterprise Sales– +1 (800) 578-6007– http://info.sandisk.com/contact-sales.html

27

Thank You!

@BigDataFlash #bigdataflash

http://bigdataflash.sandisk.com

©2015 SanDisk Corporation. All rights reserved. SanDisk is a trademark of SanDisk Corporation, registered in the United States and other countries. © 2015 SanDisk Corporation. All rights reserved. SanDisk is a trademark of SanDisk Corporation, registered in the United States and other countries. InfiniFlash, SanDisk ION Accelerator, Fusion ioMemory, ioDrive, Lightning Eco, Lightning Ascend, Lightning Ultra, Optimus Eco, Optimus Ascend, Optimus Ultra, Optimus Extreme, CloudSpeed Eco, CloudSpeed Ascend, CloudSpeed Ultra, CloudSpeed Extreme, Flash Soft and ZetaScale are trademarks of SanDisk Enterprise IP LLC, registered in the United States and other countries. Other brand names mentioned herein are for identification purposes only and may be the trademarks of their holder(s).of SanDisk Enterprise IP LLC. All other product and company names are used for identification purposes and may be trademarks of their respective holder(s).

Follow us:

SanDisk IT Blog atITblog.sandisk.com

leverage sandisk flash to optimize sql server performance and redirect customer spend to services

Technology

forwardlooking statements

sql server performance

flash storage solutions

leverage sandisk flash

b net cash

date of issuance

b revenue

end of q115 patents