Transcript Why EMC for SQL

Why EMC for SQL
Performance Optimization
EMC CONFIDENTIAL—INTERNAL USE ONLY
1
Realities in the Life of a SQL Server DBA
It’s a balancing act of expertise, cost and limited resources
Scalability, Availability, Performance
Protection and Recovery
Escalating Data Growth And Costs
(Workload/Users/Landscape)
Replication and Data Repurposing
Ever-Shrinking Backup Windows
Limited Resources, Expertise, Time
Business Intelligence and Analytics
Faster Time to Value
EMC CONFIDENTIAL—INTERNAL USE ONLY
2
Why EMC for SQL Server 2012
Mission Critical and Cloud Infrastructure Leader
3-4X More Performance
> 5 9’s Reliability & Availability
80% Faster Provisioning
Up to 10x Faster Backups
10-30x Less Backup Storage
Replicate/Recover In Minutes
EMC CONFIDENTIAL—INTERNAL USE ONLY
3
EMC Ensuring Mission Critical Confidence
Keeping Your Users Happy And Your Business Competitive
Challenge

Performance tuning is complex and manually intensive

Infrastructure investment v. scalability/growth requirements
EMC Benefit
SCALABLE
PERFORMANCE
EMC CONFIDENTIAL—INTERNAL USE ONLY

Auto-tiering eliminates manual tuning and prioritizes
Microsoft workloads to right storage tiers at the right time

80% faster SQL Server 2012 infrastructure deployments with
EMC VNX Unified Storage

Seamless scalability of SQL Server 2012 with EMC
Symmetrix VMAX & VMAXe

3-4X more performance and 80% faster provisioning of SQL
Server 2012 storage at less cost with FAST VP, FAST Cache
and vFCache
4
The FAST Suite
A FLASH 1st strategy
enabler
• FAST Cache continuously ensures that
the hottest data is served from high
performance Flash SSDs
Real-time caching
with FAST Cache
15K
Flash
Flash
SSD
HDD
• FAST VP (Virtual Pools)* optimizes
storage pools automatically, ensuring
that active data is being served from
SSDs, while cold data is moved to
lower cost disk tiers
Highcapacity
HDD
• Together they deliver a fully automated
FLASH 1st storage strategy for optimal
performance at the lowest cost
attainable
• Unisphere monitors and tunes the FAST
policies from a single interface
Scheduled optimization
with FAST VP
* Not available for VNX5100.
EMC CONFIDENTIAL—INTERNAL USE ONLY
5
FAST VP for Symmetrix VMAXe
Increasing Microsoft SQL Server Performance And Efficiency
Virtual Server
Virtual Server
Virtual Server
SQL Server SQL Server SharePoint
• FAST VP and Microsoft SQL Server
• Up To 40% Higher Performance
• 40% Lower Cost Of Storage
• Present More Capacity In Less Time While
SQL Server Applications Remain Online
FC
EMC CONFIDENTIAL—INTERNAL USE ONLY
• Less Tuning And Management Required By
SQL Server DBAs
6
Server Flash caching solution that
uses intelligent caching software and
hardware technology to reduce latency
and increase throughput
•
“Hottest” data accessed through
XtremSW Cache in the server
providing increased performance
•
XtremSW Cache benefits SQL Server
2012:
• Lower database I/O latency by
60%
• 50% more I/O serviced within 1 ms
• 4X more transactions per SQL
Server database
• Perfect fit for OLTP workloads
EMC CONFIDENTIAL—INTERNAL USE ONLY
Read Latency (Sec)
•
Transactions Per Minute (TPM)
EMC XtremSW Cache Improves Server
Performance
7