Game-changing
app performance
Performance gains just by upgrading
Record-breaking performance
PROS
100%
faster scoring
KPMG
250%
faster execution
Global ERP
700%
faster queries
Tableau
190%
faster queries
Leader in OLTP price/performance Leader in DW performance & price/performance
#1 in TPC-E price/perf (44 cores)
Windows Server 2012 R2
#2 in TPC-E price/perf (44 cores)
Windows Server 2012 R2
#1 in TPC-H 30TB (144 cores) Windows Server 2016
38% faster TPC-H 3TB (72 cores) Windows Server 2012 R2
#1 and 40% faster in TPC-H 1TB (44 cores) Windows Server 2012 R2
TPC results as of April 2016 http://www.tpc.org/default.asp
271x faster queries
Spatial line string
3.6x faster
DW queries on
AlwaysOn replicas
34x faster queries
In-memory Columnstore
10x faster
In-Memory
temp objects
15x faster
queries Table
valued parameters
20% faster
Auto NUMA
partitioning
100x faster
Batch/Bulk
operations
7x faster
throughput
AlwaysOn
19x faster
Spatial native
Functions
7-10x faster
DBCC CheckDB
20x faster
Indirect
checkpoint
2.7x faster
Batch request
per sec
3x faster
Spatial index/
queries up to
10x faster
XEvent reader
2.6x faster
DW queries
with new CE
Faster queries Faster operations Faster throughput
Microsoft confidential
