Transcript your all-flash cloud

STORAGE FOR SQL
SERVER DBA’S
HELLO, POSSIBLE
MARSHA PIERCE
SYSTEMS ENGINEER
NASHVILLE TENNESSEE
TOM MACK
SYSTEMS ENGINEER
DALLAS TEXAX
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
1
Agenda
Who is Pure?
Who is this Person Talking to Me?
Why Should DBA’s Care About Storage?
What Should DBA’s Consider When Looking At Storage?
Changes To The Storage Market Over The Last Few Years?
Q&A
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
2
IN JUST SIX YEARS…
3,000+ CUSTOMERS WORLDWIDE
INTERNET AND
MEDIA
ENERGY
TELECOMMUNICATIONS
AND SERVICE PROVIDERS
|
SOFTWARE / SAAS
FINANCE AND
INSURANCE
© 2015 Pure Storage Inc.
CONSUMER
AND RETAIL
CONFIDENTIAL – Do Not Distribute
TECHNOLOG
Y
HEALTHCARE
GOVERNMENT
AND EDUCATION
3
3
INNOVATION
RECOGNIZED
Gartner does not endorse any vendor, product
or service depicted in its research publications,
and does not advise technology users to select
only those vendors with the highest ratings or
other designation. Gartner research
publications consist of the opinions of Gartner's
research organization and should not be
construed as statements of fact. Gartner
disclaims all warranties, expressed or implied,
with respect to this research, including any
warranties of merchantability or fitness for a
particular purpose.
EMC
31%
PURE
19%
IBM
16%
NETAPP
8%
> 300%
YoY Growth
2014
HP
7%
VIOLIN
4%
#1 INDEPENDANT
All-Flash Array Vendor
LEADER
Gartner Magic Quadrant
Gartner Market Share Analysis: SSDs and
Solid-State Arrays, Worldwide, 2014
(May 1, 2015)
Solid State Arrays, June 2016
© 2015 Pure Storage Inc.
451 Research
Storage Wave 19, 2016
2 YEARS
IN A ROW
|
#1 IN PLAN
Heat
Rank
Heat
Score
Technology
Lead in
Plan
2nd in
Plan
1
1
100
100
All-FlashArrays
Arrays
All-flash
Pure
Pure Storage
Storage
EMC
2
86
Software-defined Storage
EMC!
VMware
3
85
Integrated Platforms
VCE!
Nutanix
4
81
External Cloud Storage
Microsoft
AWS
5
77
Private Cloud Storage
EMC
VMware
CONFIDENTIAL – Do Not Distribute
4
SATMETRIX NETPROMOTER SCORES
Product NPS
Support NPS
84 93
2016 Average
2016 Average
Pure Has Highest Certified Scores in B2B Enterprise
Technology
67
Apple iPhone
|
© 2015 Pure Storage Inc.
44
EMC
CONFIDENTIAL – Do Not Distribute
18
NETAPP
5
Who Is This Person?
Marsha Pierce
Database Architect and Admin for 16 years
Architect at Asurion
Architect at HCA
SQL Server, Oracle, PostgreSQL, DB2,
MySQL, Casandra, Hadoop
Large Scale OLTP database, DR, Agile
Development, Data Warehousing, Data
Lakes
Driven Storage Admins Crazy for Years
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
6
WHY
SHOULD A
DBA CARE
ABOUT
STORAGE?
Moore’s Law
In Short Processing and RAM have been doubling every two years
Moore's law refers to an observation
made by Intel co-founder
Gordon Moore in 1965. He noticed
that the number of transistors per
square inch on integrated circuits had
doubled every year since their
invention. Moore's law predicts that
this trend will continue into the
foreseeable future.
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
8
Moore’s Law
Has Not Applied to Traditional Spinning Disks
Unfortunately, performance of
traditional spinning disk storage hasn’t
increased at the same rate, which has
created a performance gap between
the CPU and the HDDs traditionally
found in SAN and NAS architectures.
In order to overcome this performance
gap, the traditional approach has been
to stitch together mass quantities of
hard drives.
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
9
In Short Storage Is Very Very Important
Storage is the biggest bottleneck for most databases
• Slows down individual query times
• Slows down bulk load
• Long Backup Times
• Long Restore Times
Things to be aware of
• Random performance issues that dissappear
• SAN Admins do not continuously run monitoring as this affects the overall performance
of the SAN
• They will tell you that they have millions of IOPS available, but what the traditional DBA
needs is low latency not large IOPS
• Auto Tiering is not as automatic as it sounds. It can take weeks for something to move up
a tier
• We often have the misconception that our data is spread across 1000’s of spindles when
it often more like 10 or 20
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
10
Are You Monitoring Your Storage?
DBA’s Actually Have The Ability To Monitor Storage Performance
From SQL Server using
• sys.dm_io_virtual_file_stats
• https://sqlperformance.com/2013/10/t-sql-queries/io-latency
• https://www.littlekendra.com/tag/sys-dm_io_virtual_file_stats/
Some symptoms of Storage Performance Issues
• Random performance issues that disappear
• Slowdowns that consistently appear at the same time and then go away
• Groups of machines having performance issues at the same time’
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
11
Misconceptions About Storage
• That storage is constantly being monitored for performance
issues
• Believing that you have 1000’s of spindles because you are
SAN based
• That Auto-Tiering is going to help speed up performance
• That you are not have storage issues because the SAN teams
says there are millions of IOPS available.
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
12
DBA’s Check List for Optimizing SAN
• Check for Disk Alignment.
•
•
•
You need a 1024 Offset
64k block size
http://www.midnightdba.com/Jen/2014/04/decree-set-your-partition-offset-and-block-sizemake-sql-server-faster/
• Do you have instant file initialization “Perform Volume Maintenance Tasks” needs to
be set under Local Policies and User Rights Assignments
• Drop Unused Indexes
• Spread your data out in file groups and data files
• Have you checked the HBA groups?
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
13
What Are Your Storage Requirements
What kind of performance do you need?
• IOPS
• Latency
• Are all IOPS the same? The array block size matters.
• Arrays do either one or the other
What is your capacity for downtime / maintenance?
• If a component fails what happens
• What do code upgrades look like
• Are you being back charged for storage.
• What happens when you need to add space
What Features Do you need:
• Encryption at Rest
• Deduplication
• Compression
• Thin Provisioning
• Clones and overhead required (Up to 5x)
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
14
Mean Time To Restore – It’s Critical!
• Typical Recovery Strategy –
• SAN based replication from point A to Point B as part of DR.
• DBA’s rely on local backups to disk to fix any production issues should they occur
Leverage Point in Time Snapshots
•
•
•
•
Databases are becoming larger and large
For 3 – 6 Terabyte Database a restore from backup can take from 4 – 6 hours
What is your SLA for recovery in the event of an outage?
Protect yourself from Data Disasters.
Snapshots Can Be Used For More Than Recovery
•
•
•
•
Refresh Your Reporting Systems and Data Lakes
Key for Agile Shops: test code with real data sets and bugs.
Reseed replication near instantly, as well as AlwaysOn AGs and LogShippping Secondaries
Use them to create templates for environments
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
15
Recent Changes To Legacy Storage
Hybrid Systems
• Legacy Arrays retrofitted with a Mix of Spinning Disks and Flash Storage
All Flash Arrays
• Usually Legacy Array Retrofitted with Flash Storage
Converged Infrastructure
• Best of Breed (Storage, Network, and Compute) pre- configured and sized for a
workload.
Hyper – Converged Infrastructure
• Multi – compute nodes with direct attached storage and networking using
software to unify these nodes
Public Cloud
• AWS & Azure
Private Cloud
• A Converged Infrastructure with features like Vmware or UCS Director
Managed by a Third Party
NVME
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
16
WHY SQL
SERVER
ON PURE?
FLASHARRAY
BLOCK
FLASHBLADE
VMs & CONTAINERS
FILE & OBJECT
+
YOUR ALL-FLASH
CLOUD
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
18
EASY. SIMPLE. FAST.
Transform Database Operations AND Database Engineering
DBAs love us because we:
• Eliminate bottlenecks from day 1
• Allow them to perform better maintenance
• Allow them to focus on projects and growth rather than firefighting slow performance
• Just plain allow them to do things they couldn’t do before!
Engineers/Developers love us because we:
• Allow for more exotic constructs to happen now that the performance is there, enabling
business cases previously thought unattainable
• Allow them to focus on expanding functionality rather than dealing with escalations from
previously deployed code
Storage folks love us because they don’t hear from DBAs that much anymore.
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
19
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
20
Q&A
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
32
|
© 2015 Pure Storage Inc.
CONFIDENTIAL – Do Not Distribute
33