all flash is not equal: tony pearson contrasts ibm flashsystem with solid-state drives (ssd)

51
#ibmedge © 2016 IBM Corporation 1348 All Flash is not created equal – Contrasting difference between IBM FlashSystem and SSD Tony Pearson, IBM Master Inventor and Senior Engineer

Upload: tony-pearson

Post on 12-Jan-2017

178 views

Category:

Technology


3 download

TRANSCRIPT

#ibmedge© 2016 IBM Corporation

1348All Flash is not created equal –Contrasting difference between IBM FlashSystem and SSDTony Pearson, IBM

Master Inventor and Senior Engineer

#ibmedge

Abstract

A comparison of IBM FlashSystem versus Solid State Drive (SSD) technology.

This session provides a history of basic chip technologies, IBM's ECC and advanced flash management techniques, Variable Striped RAID, two-dimensional RAID and other advanced features that differentiate IBM FlashSystem from SSD-based solutions.

1

#ibmedge

This week with Tony Pearson

Day Time Topic

Monday

2:30pmAll Flash is Not Created Equal: Tony Pearson Contrasts IBM FlashSystem and SSDGrand Garden Arena, Lower Level, MGM Grand - Studio A

Wednesday

11:00amAll Flash is Not Created Equal: Tony Pearson Contrasts IBM FlashSystem and SSDGrand Garden Arena, Lower Level, MGM Grand - Studio 2

1:15pmTony Pearson Presents IBM Cloud Object Storage System and Its ApplicationsMGM Grand - Room 114

2:30pmThe Pendulum Swings Back: Tony Pearson Explains Converged and Hyperconverged EnvironmentsMGM Grand - Room 113

Thursday

09:00amTony Pearson Presents IBM's Cloud Storage OptionsMGM Grand - Room 116

2

#ibmedge

Why is Everyone Excited about Flash?

Performance

Co

st p

er

GB

Disk

RAM

ROM• Block-based Solid-State Storage• Non-volatile, persistent across power loss• No moving parts, uses less power & cooling• Consistent random access, no “seek” penalty• Driven by Consumer Market

• Smart phones, Tablets• Digital cameras, MP3 players• USB thumb drives

Disk-like capacity and cost

Memory-likePerformance

Flash

3

#ibmedge

History of Flash Memory

Read-Only Memory (ROM)• Hardwired at the factory• Cannot be erased or re-written• Used for “boot programs” and BIOS• Embedded mass-produced systems

Programmable ROM (PROM)• Manufactured as blank

memory• Can be written only

once, with PROM burner device

Erasable PROM (EPROM) • “firmware”• reusable, erased by Ultra-

Violet (UV) light• Written using an external

EPROM burner device

Electrically Erasable PROM (EEPROM)• reusable, erase and

write bytes using voltage levels in place on circuit board

• No need to use burner

Why NAND instead of NOR technology?• Offers higher densities, larger capacities,

and lower cost • Faster erases, sequential writes, and

sequential reads• Best suited to systems requiring high

capacity data storage

NOR Flash• Erase blocks• Write bytes

NAND Flash• Erase blocks• Write pages

ROMBurner

EPROM

EEPROM

4

#ibmedge

Multi-Level Cell (MLC) holds Two Bits (11, 10, 00 or 01)

11 0110 00

LowVoltage

HighVoltage

Erase – set to 11

Program 10

Program 00

Program 01

“Under-programmedBit Error 00 ���� 10

“Over-programmed”Bit Error 00 ���� 01

Wrote“00”

5

#ibmedge

Flash is Organized in a Hierarchy

Cell

Multi LevelCell (MLC)Holds 2 bits“00”, “01”,“10”, “11”

65,536Cells

Page

512Pages

Block

2Planes

2,048Blocks

Plane Die

16 KiB 8 MiB 16 GiB

4Dies

Chip

32 GiB 128 GiB = 1 Tb

Odd

Even

• Read Page• Program Page• Erase Block

With two panes, a die can perform 2 reads, 2 writes or 2

erases concurrently

6

Four dies = Four independent

operations

#ibmedge

ReclaimValid data written

to new block(Write Amplification)

Understanding the Flash Program/Erase Cycle (P/E Cycle)

EmptyBlock

PartialFull

EmptyBlock

ErasePrepares block

to be written again

PartialFull

Pages cannot be “re-written”

To update data,read the old page,

write new pageInvalidate old page

x

x

x

x

FullBlock

x

EmptyBlock New

Block

x

x x

xx x

x x

x

All pages onold block

invalidated

Program“Write Page”

Write Endurance: The number of times Flash block can go through a Program/Erase cycle before failing. Typically ~ 10,000 cycles for MLC

Eventually, block

becomes full

7

#ibmedge

Flash Memory

• Very fast (low latency)

• Non volatile, Inherently rugged

• Very low power

Flash can be packaged into a variety of forms

Pretend to bememory

Specialized Card

Pretend to be Spinning Disk

Slower than DRAM, but non-

volatile

Excellentperformance

Faster than Spinning Disk

Disruptive Hot swappable

DIMMPCiEBoard

Solid-StateDrive (SSD)

8

#ibmedge

Solid State Drives – Flash pretending to be Spinning Disk

Stepper MotorSpindle Motor

Arm

Read/Write Head

SASSATAFCP

SASSATAFCP

SameControllerProtocols

Same Length

Same Width

Same Height

If the read/write head comes in contact with the surface of the platter at full speed, the result can be loss of data, damage to head, damage to surface, or all three.

This is known as a “Head Crash”

Chip fails on SSD

This is treatedthe same as a “Head Crash”

SameFailure codes

9

#ibmedge

Solid State Drives (SSD) vs. IBM MicroLatency™ Module

CUSTOM

Requires hardware engineering

FAST

Designed for low latency

RELIABLE

Innovative flash management

COMMODITY

No hardware skills needed

SLOW

Designed for low cost

FALLIBLE

More single points of failure

Better Performance

Better Reliability

Better Density Lower $/IOPS

IBM FlashCore™ Technology�Hardware Accelerated I/O�IBM MicroLatency™ Module�Advanced Flash Management

Spinning Disks

5-15 milliseconds

100-200 microseconds, Up to 57TB in 2U

~1 milliseconds(1000 microseconds)

Solid State Drives (SSD)

10

#ibmedge

Hardware accelerated I/O

IBM MicroLatency™ module

Advanced flash management

Industry standard chip technology

Industry standard interfaces

Introducing IBM FlashCore™Dynamic performance

11

#ibmedge

Heat Segregation and Health Binning

EmptyBlock

EmptyBlock

EmptyBlock

EmptyBlock

Write Amplification =Total writes

Host writes

Heat SegregationBy segregating hot data from cold data,IBM achieved 45% reductionin Write Amplification!

hot

warm

cold

Health BinningDuring background operations, the health of each block is determined.Hottest data is written to healthiest blocks, cold data written to less healthy blocks. This improves Write Endurance by 57%

Healthiest Blocks

Least Healthy Blocks

12

#ibmedge

Data Scrubbing

Over time, electron charge of the cell decays, shifting everything to the left

Data scrubber reads data over the course of days or weeks to predict uncorrectable errors

At-risk data is read, corrected, and written to new pages while still correctable

Dynamic Read Voltage Shifting

While scrubbing, IBM controller performs real-time analysis to determine read voltage

With Dynamic Read Voltage Shifting, thresholds track decaying charge

Error rates appear unchanged from their original post-programming values

Multi-Level Cell (MLC) – Data Scrubbing and Voltage Shifting

11 0110 00

LowVoltage

HighVoltage

11 0110 00

13

#ibmedge

Error Detection and Correction Codes (ECC)

Bose Chaudhuri Hocquenghem (BCH)A class of cyclic error-correcting codes that are constructed using finite fields. BCH codes can correct multiple bit errors with a simple algebraic method that can be implemented with low latency (fast)

Low-Density Parity Check (LDPC)A powerful ECC algorithm that dates back to the 1960s. It is computationally intensive and has higher latency (slower)

IBM Error Correcting CodeAn innovative algorithm that provides fast, low latency similar to BCH codes, but is able to correct more multiple bit errors similar to LDPC

14

#ibmedge

IBM FlashCore – Advanced Flash Management

The bit error rate (BER) is the number of bit errors per unit time. It increases as more P/E cycles occur to the Flash chip

Standard MLC

IBM ECC increases the bit error rate tolerance, allowing more P/E cycles

IBM Heat Segregation, Health Binning, Dynamic Read Voltage Shifting improves Write Endurance

Combined benefit 9.4x Endurance

15

#ibmedge

IBM FlashCore Technology: IBM MicroLatency™ Module

• IBM Engineered

• Massively Parallel Design

• FPGAs in the Data Path

• Distributed RAM

• High Speed Interface

• Hardware-based Data at Rest Encryption

13 Chips 32 Chips 64 Chips

1.2 TB usable 2.9 TB usable 5.7 TB usable

16

#ibmedge

IBM FlashSystem – Variable Striped RAID (VSR)

Chip 1

P1

P511

P342

P2

P172

P512

P171

Chip 2 Chip 3 Chip 16

Page–Based RAID The pages across each chip represent a RAID-5 group with Interspersed Rotating Parity

1.2 TB 12+P

2.9 TB 15+P (2 sets)

5.7 TB 15+P (4 sets)

Page-based Rebuild If a page fails, the data is reconstructed from parity, and written to the other pages on the same set of chips.

Variable Striped RAIDThe RAID group is then re-defined without the failed page:15+P ���� 14+P ���� 13+P etc.

P1

P511

P342

P2

P172

P512

P171

P1

P511

P342

P2

P172

P512

P171

P1

P511

P342

P2

P172

P512

P171

P341 P341P341 P341

17

#ibmedge

Form Factor SSD• Flash failure = Disk failure• Requires top-level RAID• Relatively frequent hot-swaps

Enterprise Flash Drive or Memory Module• Flash failure = Degraded state within

module• Performance impact on RAID set• Hot-swap to resolve

FlashSystem with Variable Stripe RAID

• Preserves Flash life• Preserves performance• Re-parity data in microseconds

Parity

Parity

No Parity

Less maintenance touches while still preserving the life, protection, and performanceof the Day-1 experience

Value of Variable Stripe RAIDTM

IBM Variable Stripe RAID™ (VSR) Comparison

18

#ibmedge

IBM FlashCore Technology: Hardware Accelerated I/O

• Engineered for Flash

• Hardware RAID

• Non-blocking Crossbar Switch

• Hardware Only Data Path

• Single Box Highly Available Architecture

• Concurrent Code Load

• Concurrent Maintenance

Canister-1 Canister-2

FC-1

MC-2MC-1

FC-3 FC-4FC-2

XBAR 0 XBAR 1

2-Dimensional RAID5 (10+P+S)

V

SR

19

#ibmedge

FlashCore vs. the Competition

� Commodity SSDs

� Using open source SCSI layer and

off-the-shelf HDD-optimized data

path

� Many use software RAID which

often cripples RAID 5 performance

� IBM MicroLatency Module with

Advanced Flash Management

yields greater density and longevity

� No software in the data path for

better and more consistent

performance

� Two-dimensional flash RAID for

enhanced data protection

The Competition

The CompetitionThe Competition

The CompetitionIBM FlashCore technology

IBM FlashCore technologyIBM FlashCore technology

IBM FlashCore technology

Better TCO and faster time to value

Better application performance at peak demand

Better business insights from faster analytics

Better budgeting and storage growth planning

20

#ibmedge

I/O Serviced by Disk

� CPU Utilization = 200 / 5,200 = ~4%

Time

Processing~100 µs ~100 µs

Waiting

~5,000 µs

1 I/O Request

CPU State

I/O Serviced by IBM FlashSystem

� CPU Utilization = 200 / 400 = 50%

Time

Processing~100 µs ~100 µs

Waiting

~200 µs

1 I/O Request

CPU State

12X Application benefit by only

changing storage latency!

Microsecond latency maximizes CPU utilization

21

#ibmedge

All Flash…

Over 30% LessExpensive Systems

���� 38% Lower Software License Costs– Fewer cores, lower maintenance – Database, infrastructure SW…

���� Higher Storage Utilization– As much as 50%– Lower maintenance – Simplified management

���� 17% Fewer Servers– Fewer cores– Fewer network connections– Lower maintenance

���� 74% Lower Environmental Costs– Power / cooling, floor space

���� 35% Lower Operational Support Costs– Server / storage administration

Source: Wikibon, March 2013

“spectacular”; processing huge number of transactions in one day, lower response times…

…75% less rack space, 90% less power, 83% faster

data compression…

SAP

…5TB in 3.5 inches of rack space vs.1,300 disk for 400K IOPs,

less than 1/10th the cost…

Cloud Storage

Source: IBM Client Experiences

Disk

$7.1M

Flash

$4.9M

Core Financial Transactions

All-Flash is About Economics

22

#ibmedge

IBM Storage Portfolio – FlashSystem

Spectrum ScaleElastic Storage Server

IBM Spectrum Virtualize

IBM Spectrum Accelerate

FlashSystem XIV

DS8000

All-FlashFlash/Disk

Hybrid

For absolute performance, low latency, high IOPS and bandwidth

FlashSystem 900

For enterprise functionality of IBM Spectrum Virtualize with the benefits of FlashSystem

FlashSystem V9000

For enterprise functionality of IBM Spectrum Accelerate with the benefits of FlashSystem

FlashSystem A9000

and A9000R

23

#ibmedge

FlashSystem 900

Introducing IBM FlashSystem 900, the next generation in our lowest latency offering

• IBM MicroLatency™ with up to 1.1 million IOPS

• IBM FlashCore™ technology

• Technical collaboration with Micron Technology, our flash chip supplier

• IBM enhanced flash technology

• MLC NAND flash offering with Flash Wear Guarantee

• VAAI UNMAP and VASA support with Spectrum Control Base for improved cloud storage performance and efficiency

• POWER8 CAPI

Minimum latencyWrite 90 µs

Read 155 µs

Maximum IOPS 4 KBRead (100%, random) 1,100,00

Read/write (70%/30%, random) 800,000

Write (100%, random) 600,000

Maximum bandwidth 256 KBRead (100%, sequential) 10 GB/s

Write (100%, sequential) 4.5 GB/s

Performance at-a-glance

IBM MicroLatency module type

1.2 TB 2.9 TB 5.7 TB

Modules quantity 4 6 8 10 12 6 8 10 12 6 8 10 12RAID 5 capacity (TB) 2.4 4.8 7.2 9.6 12 11.6 17.4 23.2 29.0 22.8 34.2 45.6 57.0

24

#ibmedge

IBM MicroLatency Modules (12)

RAID Controllers (2)

Battery Packs (2)

Power Supplies (2)

Fan Packs (4)

Interface Modules (4)

Management Modules (2)

Canisters (2)

IBM FlashSystem 900 components

• 8Gb or 16Gb Fibre Channel

• 40Gb InfiniBand

• 10Gb Fibre Channel over Ethernet (FCoE)

• 10Gb iSCSI

25

#ibmedge

IBM Storage Portfolio – Spectrum Virtualize

IBM FlashSystem V9000

Storwize V7000 Unified

SAN Volume Controller

Storwize V7000Storwize V7000F

Storwize V5000Storwize V5000F

Common Advanced Virtualization Code BaseMany Different Packages

Spectrum ScaleElastic Storage Server

IBM Spectrum VirtualizeSVC, Storwize

IBM Spectrum Accelerate

FlashSystem XIV

DS8000

All-FlashFlash/Disk

Hybrid

26

#ibmedge

IBM FlashSystem V9000

IBM introduces a fully integrated, flexible, feature rich all-flash storage system

IBM’s choice for distributed system tier 1 storage

• Scalable all-flash architecture accelerates applications and entire infrastructures

• Performs at up to 2.5M IOPS with IBM MicroLatency

• Up to 57TB usable (285TB effective capacity) in only 6U and scales to 456TB usable (2.28PB effective capacity) in only 34U

• New licensing structure to simplify ordering and planning for External Data Virtualization, FlashCopy, Metro Mirror, and Real-time Compression

• FlashSystem Tier 1 Guarantee

Scalable Performance Agile IntegrationEnduring Economics

Powered by IBM FlashCore™ Technology

27

#ibmedge

• More options to choose from

• Capacity-based License

• Requires SAN infrastructure

• Simplified options

• Enclosure-based License

• Can be direct-attached or SAN

SVC with FlashSystem 900 vs. FlashSystem V9000

28

2 SAN Volume Controllers(node-pair or I/O Group)+FlashSystem 900(dual controller)

FlashSystem V9000

#ibmedge

SAN

Cluster up to 3 more Building blocks

IBM FlashSystem V9000 Upgrade Options

Start with 1 Building block

Virtualize storage from IBM, EMC, HDS, HP, NetApp, Dell, NEC, Fujitsu, Oracle and others

Add up to 4

Flash Enclosures

Add up to 2

Nearline diskEnclosures

29

#ibmedge

IBM Real-time CompressionExpected Compression Ratios

�Real-time Compression uses proven Random-Access Compression Engine (RACE)

�45-day Free Trial of Compression available

�Comprestimator tool included in Spectrum Virtualize v7.6

DB2 and Oracle databases ~ 80% 5x

Virtual Servers (VMware)

Linux and Windows

Virtual guest images

50% to 70% 2x to 3x

Microsoft Office2003 ~ 60% 2.5x

2007 or later ~ 20% 1.3x

CAD/CAM ~ 70% 3x

• This pre-sales “Comprestimator” tool is available to estimate compression savings, percentage savings shown are typical results, based on client experiences, your mileage may vary.

• http://www14.software.ibm.com/webapp/set2/sas/f/comprestimator/home.html

30

#ibmedge

Database Compression

Use Database Compression when

• Fastest performance is required

• Lowest price/performance is a priority

• Workload primarily contains moderate to heavy sequential writes

StorageCompression

Use Storage Compression when

• Primary focus is quantity of storage consumed

• Minimize server CPU

• The workload is primarily random I/O:

– OLTP Databases

– Server Virtualization

– Virtual Desktop Infrastructure (VDI)

– Collaboration

– Engineering, Seismic, CAD/CAM

•Plenty of non-database data also compressed

When Should Clients Use Database Compression vs. Storage Compression?

SAN

CPU

Use Comprestimator, DB2 Compression Estimator, Disk Magic and/or IBM Spectrum Control to evaluate your workload today!

#ibmedge

PERFORMANCEField-proven IBM

FlashCoreTM technology

drives consistent MicroLatency

PARALLEL ARCHITECTURE

Grid capabilities, originally pioneered by IBM XIV, make scaling simple and easy

DATA SERVICESIntegrated data services, based on IBM Spectrum

Accelerate, provide security and protection

FLASH-OPTIMIZATIONIBM Research optimized reduction

features, like deduplication and

compression, for the speed of flash

SIMPLE MANAGEMENT

The innovative new interface has earned more than 15 patents, and

is based on the award winning XIV GUI and extensive customer

feedback

Built with

Only IBM can integrate best-in-class resources to solve customers’ most critical hybrid cloud challenges

32

#ibmedge

• More options to choose from

• 3 to 15 nodes in cluster

• FlashSystem, SSD, or HDD

• Hyperconvergence

• iSCSI interface only

• Simplified options

• 3 nodes, all Flash

• Pattern removal, dedupe and HW-based compression

• FCP and iSCSI supported

Spectrum Accelerate vs. FlashSystem A9000

33

3 Spectrum Accelerate Nodes (grid nodes)+FlashSystem 900(dual controller)

FlashSystem A9000

#ibmedge

IBM FlashSystem A9000R

34

2 Spectrum Accelerate Nodes+FlashSystem 900(dual controller)

FlashSystem A9000R

1 Based on a 5.26 to 1 data reduction ratio; 2 70/30 read/write

2-6 A9000R Grid Elements

Infiniband switches

#ibmedge

Data Footprint Reduction Methods

• 8KB pattern detection• Patterns -- static database of popular fingerprints

• More efficient than dedupe in both time and space

• There are currently ~260 patterns

• Deduplication

• Compression

64KB user write

Pattern removal

Deduplication Compression

Data Type

Dedupe Compress Combined

Virtual Desktop (VDI)

16.7x 2x 33x

KVM –Linux guests

1.9x 3.8x 7.2x

Database Restore + Test

1.02x 4.2x 4.2x

35

#ibmedge

IBM FlashSystem Models

36

900 V9000 A9000 A9000R

Tier 0 – Lean &Mean Tier 1 – Robust functionality

Data at Rest Encryption 256-bit AES

Optimized for:• Application

Boost

Optimized for:• Traditional SAN• Databases• Automated Tiering• Virtualize almost 400

vendor devices

Optimized For:• Cloud / Multi-tenancy• Virtual Desktop

Infrastructure (VDI)• Virtual Machines

• VMware, HyperV, etc.

#ibmedge

7 year 24x7 Support:Up to 7 years support available with optional price protection and flash media retention offerings

NEW Enterprise Class Support

Data Footprint Reduction:Capacity Guarantee –to the specified product capacity (e.g., 300 TB, 1.8 PB) Competitor Match Guarantee – match any demonstrated FlashSystem Competitor guarantee for specified dataNEW Pattern removal, deduplication, & compression on A9000 and A9000R

Endurance:IBM FlashCore ensures that Flash memory will be covered for read/write endurance while you are under warranty or maintenance

Peace of Mind:No charge, complimentary IBM services, like training, configuration, and consultation, for all tier 1 opportunitiesNEW Perpetual Licensing with IBM Spectrum Storage Suite

Performance:IBM MicroLatency™ performance with full-time data footprint reduction

Tier 1 Guarantee for IBM FlashSystem

37

#ibmedge

IBM Software Defined Storage Data Plane

IBM Software Defined Storage Control Plane

IBM for Software Defined Storage

Control Protect

IBM ranked #1 in All-Flash Arrays

Accelerate Virtualize Scale Archive

IBM FlashSystem 900• World’s Fastest Storage

IBM Spectrum Virtualize• IBM FlashSystem V9000 inherits the

rich functionality of IBM Spectrum Virtualize software

• Real-time Compression

IBM Spectrum Accelerate• IBM FlashSystem A9000 and

A9000R inherit the rich functionality of IBM Spectrum Accelerate software

• Pattern Removal, Data Deduplication and Real-time Compression

38

© 2016 IBM Corporation #ibmedge

Thank You

#ibmedge

DS8880

FlashSystem A9000

IBM FlashSystem in the IBM Storage Portfolio

IBM FlashCore™ Technology Optimized

FlashSystemA9000R

FlashSystemV9000

StorwizeV7000

All flash array for virtualizing the hybrid Data Center

• Best performance with storage services & selectable data reduction

• Targeting database/ analytics workloads

Mid-Range

• Extreme performance• Targeting database acceleration &

Spectrum Storage booster

All flash array for cloud service providers

• Best performance with full time data reduction

• Targeting VDI and VMware

FlashSystem 900

All flash array for application acceleration

Storwize V5000

XIV Gen3

High End Capacity Optimized

Entry / Mid-Range

All flash array for large deployments

• Best performance with full time data reduction

• Targeting mixed workloads

SVC

High End

Server

-Mainframe

-Power

• Extreme

reliability

and

replication

• Available in

All Flash &

Hybrid

configuratio

ns

40

#ibmedge| 41

4141

41IBM FlashSystem © 2016 IBM Corporation

For more Information

• Product Pages:

– IBM FlashSystem 900

– IBM FlashSystem V9000

– IBM FlashSystem EcoSystem

• Resources: ibm.com/storage/flash/resources

• Compression Estimator Tool: http://www-304.ibm.com/webapp/set2/sas/f/comprestimator/home.html

• Workload Estimator Tool: http://www.ibm.com/systems/support/tools/estimator

• Energy Estimator Tool: http://www.ibm.com/systems/support/tools/estimator/energy .

Twitter: #FlashSystem, #IBMFlash, #FlashRealized

Flash website: ibm.com/storage/flash/

41

#ibmedge

IBM Redbooks on IBM FlashSystem

42

Implementing IBM FlashSystem 900

Introducing and Implementing IBM FlashSystem V9000

IBM FlashSystem A9000 Product Guide

IBM FlashSystem A9000R Product Guide

www.redbooks.ibm.com

#ibmedge

Advantages

Compressed data is read as is into DRAM memory

• More records per I/O request

• Faster full-database scans

• Reduced SAN traffic

Compressed data consumes less storage space

• Typically reduces database disk requirements by 60% (2.5 x)

• Improves economics for Flash and SSD

Disadvantages

Compression consumes more CPU resources

• May increase your per-core software licenses to database vendor

• May increase number of servers needed to handle your business workload

• Slower INSERT and UPDATE of individual rows

Does not compress other types of data

• 80% of your data is unstructured content outside of databases

Advantages and Disadvantages to Database Compression

SAN

CPU

#ibmedge

Advantages

Compressed data consumes less storage space

� Typically reduces database disk requirements by 80% (5x)

� Improves economics for Flash and SSD

Does not consume server CPU resources

Compress all types of data

� Not just your database tables and indexes

Disadvantages

Uncompressed data read into DRAM

� Does not reduce memory requirements for database

� Does not reduce SAN traffic

Consumes more storage CPU resources

� May impact I/O operations of other applications

� May reduce total IOPS and throughput capability of the storage device

Advantages and Disadvantages to Storage Compression

SAN

CPU

#ibmedge

Conventional Wisdom Holds – Do Not Compress Compressed Data Except In Very Specific Situations

• Turned on both database and storage compression

• Results

• Performance much lower than DB2 compression and even lower than uncompressed

• Price of transactions greatly increased

• Even a DB2 database with deep compression may have large amounts of free space interspersed between segments of compressed data.

• This is done for performance reasons and in this scenario it might make sense to use both types of compression at the same time.

#ibmedge

IBM Tucson Executive Briefing Center

• Tucson, Arizona is home for storage hardware and software design and development

• IBM Tucson Executive Briefing Center offers:

• Technology briefings

• Product demonstrations

• Solution workshops

• Take a video tour!

• http://youtu.be/CXrpoCZAazg

46

#ibmedge

About the Speaker

Tony Pearson is a Master Inventor and Senior Software Engineer for the IBM Storage product line. Tony joined IBM

Corporation in 1986 in Tucson, Arizona, USA, and has lived there ever since. In his current role, Tony presents briefings on

storage topics covering the entire IBM Storage product line, IBM Spectrum Storage software products, and topics related to

Cloud Computing, Analytics and Cognitive Solutions. He interacts with clients, speaks at conferences and events, and leads

client workshops to help clients with strategic planning for IBM’s integrated set of storage management software, hardware, and

virtualization products.

Tony writes the “Inside System Storage” blog, which is read by hundreds of clients, IBM sales reps and IBM Business Partners

every week. This blog was rated one of the top 10 blogs for the IT storage industry by “Networking World” magazine, and #1

most read IBM blog on IBM’s developerWorks. The blog has been published in series of books, Inside System Storage: Volume

I through V.

Over the past years, Tony has worked in development, marketing and customer care positions for various storage hardware and

software products. Tony has a Bachelor of Science degree in Software Engineering, and a Master of Science degree in

Electrical Engineering, both from the University of Arizona. Tony holds 19 patents for inventions on storage hardware and

software products.

9000 S. Rita Road

Bldg 9032 Floor 1

Tucson, AZ 85744

+1 520-799-4309 (Office)

[email protected]

Tony Pearson

Master Inventor

Senior Software Engineer

IBM Storage

47

#ibmedge

Email:[email protected]

Twitter:twitter.com/az990tony

Blog: ibm.co/Pearson

Books:www.lulu.com/spotlight/990_tony

IBM Expert Network on Slideshare:www.slideshare.net/az990tony

Facebook:www.facebook.com/tony.pearson.16121

Linkedin:https://www.linkedin.com/in/az990tony

Additional Resources from Tony Pearson

48

#ibmedge

Please Note: Edge 2016 Disclaimers

• IBM’s statements regarding its plans, directions, and intent are subject to change or withdrawal without notice and at IBM’s sole discretion.

• Information regarding potential future products is intended to outline our general product direction and it should not be relied on in making a purchasing decision.

• The information mentioned regarding potential future products is not a commitment, promise, or legal obligation to deliver any material, code or functionality. Information about potential future products may not be incorporated into any contract.

• The development, release, and timing of any future features or functionality described for our products remains at our sole discretion.

• Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon many factors, including considerations such as the amount of multiprogramming in the user’s job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve results similar to those stated here.

49

#ibmedge

Trademarks and Other Disclaimers

50

Adobe, the Adobe logo, PostScript, and the PostScript logo are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States, and/or other countries. IT Infrastructure Library is a registered trademark of the Central Computer and Telecommunications Agency which is now part of the Office of Government Commerce. Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel Centrino logo, Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries. Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. ITIL is a registered trademark, and a registered community trademark of the Office of Government Commerce, and is registered in the U.S. Patent and Trademark Office. UNIX is a registered trademark of The Open Group in the United States and other countries. Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates. Cell Broadband Engine is a trademark of Sony Computer Entertainment, Inc. in the United States, other countries, or both and is used under license therefrom. Linear Tape-Open, LTO, the LTO Logo, Ultrium, and the Ultrium logo are trademarks of HP, IBM Corp. and Quantum in the U.S. and other countries.

Other product and service names might be trademarks of IBM or other companies. Information is provided "AS IS" without warranty of any kind

The customer examples described are presented as illustrations of how those customers have used IBM products and the results they may have achieved. Actual environmental costs and performance characteristics may vary by customer.

Information concerning non-IBM products was obtained from a supplier of these products, published announcement material, or other publicly available sources and does not constitute an endorsement of such products by IBM. Sources for non-IBM list prices and performance numbers are taken from publicly available information, including vendor announcements and vendor worldwide homepages. IBM has not tested these products and cannot confirm the accuracy of performance, capability, or any other claims related to non-IBM products. Questions on the capability of non-IBM products should be addressed to the supplier of those products.

All statements regarding IBM future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only.

Some information addresses anticipated future capabilities. Such information is not intended as a definitive statement of a commitment to specific levels of performance, function or delivery schedules with respect to any future products. Such commitments are only made in IBM product announcements. The information is presented here to communicate IBM's current investment and development activities as a good faith effort to help with our customers' future planning.

Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon considerations such as the amount of multiprogramming in the user's job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve throughput or performance improvements equivalent to the ratios stated here.

Prices are suggested U.S. list prices and are subject to change without notice. Starting price may not include a hard drive, operating system or other features. Contact your IBM representative or Business Partner for the most current pricing in your geography.

Photographs shown may be engineering prototypes. Changes may be incorporated in production models.

© IBM Corporation 2016. All rights reserved. References in this document to IBM products or services do not imply that IBM intends to make them available in every country.

Trademarks of International Business Machines Corporation in the United States, other countries, or both can be found on the World Wide Web at http://www.ibm.com/legal/copytrade.shtml.

ZSP03490-USEN-00