HPE Storage solutions for SQL Server

#HPEMSFT

Rambo WANGTME, HPE Storage

Top challenges for SQL Server infrastructure

2

Lost nights and weekendsHow can we spend less time on endless firefighting, troubleshooting, and maintenance?

Cost of rapid data growthDid you know that data copies now consume more space than production data?

Need for faster innovation How can we deliver new applications and ideas to market faster?

There is always an HPE Storage solution suits your environment!

Different infrastructure and storage consumption patterns

3

On-premise and off-premise workloads

On-premiseworkloads

IT bornin the cloud

– There is always an HPE Storage solution suits your environment!

Systemautomation

Containerplatforms

Containertypes

Popular use cases

‒ Data protection

‒ Business continuity

‒ Development and testing

‒ Reporting, analytics, audit, security, patches and updates, and more…

Consistent performance with predictive flash

99.9999% guaranteed availability

from storage

HPE Storage solutions for SQL ServerThere is always an HPE Storage solution suits your environment!

4

Worry-free SQL Server infrastructure with AI for the data center

Fast, efficient SQL Server copy data management for hybrid cloud

DevOps and cloud ready

A simple SQL Server in a department or ROBO

5

SimpliVity

• Virtual Environment simplicity for Compute and Storage, even Network as well;

• Minimal management effort with maximize data efficiency;

• Build-in VSS-aware Snapshot to keep SQL Server data consistency during backup and DR replication;

• Build-in HW Data Deduplication/Compress to keep Windows/SQL maximum compatibility;

Legacy servers and hypervisor

Storage switch

HA shared storage

SSD array

Backup and dedupe

WAN optimization

Cloud gateway

Storage caching

Data protection apps (backup and replication)

Complex, Manual Networking

SQL VM

SQL VM

Web VM

App VM

File VM

Windows Server / Hyper-V

Storage Luns

SQL VM

SQL VM

Web VM

App VM

File VM

Windows Server / Hyper-V

Storage Luns

SQL VM

SQL VM

Web VM

App VM

File VM

Windows Server / Hyper-V

Storage Luns

SQL VM

SQL VM

Web VM

App VM

File VM

Windows Server / Hyper-V

Storage Luns

SQL Servers in Data Centers

6

HPE SimpliVity Data Virtualization

Platform

Global ROBO Data Efficiency

Data Centers

SimpliVity

HPE Primary Storage Array

HPE Storage solutions for SQL Server @ on-premise DC

7

• All Flash-optimized • Predictive• Tier-1 with 6*9s;• Full PowerShell script-able

HPE 3PAR-A

Peer PersistenceSynchronous replication

HPE 3PAR-C

HPE Primary Storage Array3PAR/Nimble

HPE 3PAR-B

Peer Persistence + 3DC • Concurrent metro-distance synchronous

copy and continental distance asynchronous copy for a single volume

Async

Peer Persistence• RPO + RTO = 0• High Availability across metro

distances• Automatic Transparent Failover

HA+DR with Peer Persistence + 3DC, anything else?

8

• All Flash-optimized • Predictive• Tier-1 with 6*9s;• Full PowerShell script-able

HPE 3PAR-A

Peer PersistenceSynchronous replication

HPE 3PAR-C

HPE Primary Storage Array

HPE 3PAR-B

Peer Persistence + 3DC • Concurrent metro-distance synchronous

copy and continental distance asynchronous copy for a single volume

Async

Peer Persistence• RPO + RTO = 0• High Availability across metro

distances• Automatic Transparent Failover

👿👿

Pay and Pray“…unencrypt may not work”

FBI link

A backup plan is always required and should be executed!

HPE unique RMC-S “Flash to Cloud” Data Protection

9

HPE 3PAR

Nimble*

HPE RMC-S– Application managed data protection – Protecting workloads at the speed of

flash - 23x faster backup, 15x faster restore by Express Protect/Restore

– Backup with zero impact to DB servers, comparing to nomrla SQL Backup will typically impacts DB transactions/sec by 5x (from Evaluator Group testing )

– Copy Data Management not only to local Backup Appliance but also to Public/Private Cloud in Dedupe/Compression/Encrypted format;

– Minimal cost and complexity – backup direct from 3PAR to StoreOnce

– Protects both physical and virtualized SQL Servers;

Cloud Bank Storage

Azure/AWS/Scality

HPE StorageStoreOnce

23x Faster backup15x Faster restore

HPE RMC

Is SQL Server Backup always slow?

• Heavy load on storage during backup• The backup window will be long• During restore, after DB files restored, the log files

has to be restored/replayed again, affecting RTO;

Log file being copiedDB checkpointcreated

Log file captures all write IOs during backup

I/O

t

• Minimum load on storage during backup with Express Protect

• SQL Server log files to be copied almost Zero• During restore, barely no log reply;

I/O

t3PAR Snapshot

Created3PAR Snapshot

Delete

From SQL server POV, backup window 0

DB checkpoint. created

Backup finishedFile copy

Backup Solutions for other storage platforms

11

Any Storage Platform

HPE Catalyst Plugin for MS SQL Server– Application managed data protection – Copy Data Management not only to

local Backup Appliance but also to Public/Private Cloud in Dedupe/Compression/Encrypted format;

– Minimal cost and complexity – No extra license required except HPE StoreOnce Backup Appliance with Catalyst license

Cloud Bank Storage

Azure/AWS/Scality

HPE StorageStoreOnce

HPE StoreOnce Catalyst Plug-in for MS SQL/Oracle/SAPHANA

Intelligent SQL data processing

SQL Server: Virtual Backup Device Interface (VDI) API

Enabling off-premises data protection for Azure StackHPE Cloud Bank Storage and Azure Blob Storage

For HPE and Channel Partner internal use only 12

HPE ProLiant for Microsoft Azure Stack running workload VMs

HPE StoreOnce appliance

(on-premises)

Veritas NetBackupmedia server

Azure Blob Storage

On-prem private cloud object store

Public cloud(xSP)

HPE

Clo

ud B

ank

Stor

age

Key benefits– Wide choice of cloud deployments

– Cost-effective and high performance with long-term retention

– Reliable disaster recovery using off-site backup data copies without having to invest in off-site facilities

Questions?

13

Thank you!