Transcript Enhanced Performance

SQL 2016 new Hosting Offers
Secure Database
Hybrid HyperScale
Enhanced Performance
Hybrid Analytics
Row Level Security
Data Masking
Transparent Data Encryption
Temporal Database
Stretch Database
AlwaysOn Replica in Azure
In-Memory OLTP
Enhanced Always On
Real time reporting on
Replica Round-Robin
In-Memory OLTP
Query Store
PolyBase (with HDInsight
connect)
Power BI
Data Security Policy
Implementation
Security Audit
Support for Compliance,
Incident Detection,
Recovery
Historical Data Management
OLTP/Reporting Workload
Optimization
Acquisition & Integration of
non-relational data sources
with SQL Server
Customer segments: MM –
Enterprise, SMB
Customer segments: MM –
Enterprise, SMB
Limitless expandable
storage options
Low cost Performance
tuning and troubleshooting
Customer segments: MM Enterprise
Custom dashboards on
hosted data
Customer segments: MM –
Enterprise
7x faster throughput just by upgrading
SQL Server 2016
Delivers unparalleled performance
1
1
1
#1 in 30TB, 3TB, 1TB TPC-H
Windows Server 2016
Performance gains
just by upgrading
TPC results as of April 2016 http://www.tpc.org/default.asp
#1 in TPC-E & 1TB,
3TB, 10TB, 30TB TPC-H
Windows Server 2016
1000x faster scoring
Why Enhanced Performance?
Customers are demanding even higher concurrency and lower latency, at a
lower cost
In-Memory
Query Store
Enhanced
AlwaysOn
ColumnStore
Provides 30%
performance
improvement out of
the box. Reach up to
30X faster transactions
with OLTP and 100X
faster queries
Automatically
monitors and
optimizes query plans
with full history.
Provides load
balancing on readable
secondary databases
Runs real-time report
of operational data
using without
impacting
performance.
Key Benefits
•
Instantly faster transaction
and query speed without
new hardware CAPEX.
•
Improved application
performance scaling and
service availability.
•
Performance tuning made
easy with real-time
reports.
Hoster scenario – Enhanced Performance
Partner offers
• High-speed trading for financial institutions
• High-volume E-Commerce scenarios
• High performance data warehousing
HSP Benefits
HSP Value-Add Opportunities
• Increase performance with no
hardware investment
• Reduce cost and simpler architecture
for data warehouse solutions
• Improve hardware TCO without CAPEX
•
•
•
Performance tuning
Scalability analysis
Provisioning for scale
About the Calculator
• Model single customer or
total business revenue,
costs and profitability
• You will need to gather info
about customer or service
sizing requirements.
• List of potential value
added services has been
included but could be
changed based on your
company focus and
expertize.
Enhanced Performance Profitability
Providing an e-commerce customer with unparalleled, fine tuned performance with SQL 2016
Scenario Description
Profitability Model*
$2,400
$109,268
Partner Opportunity
Value-add
Services
Value-add
markup
$54,634
Total Monthly Profit = $166,302
Value-add
Services