Why SQL 2016 rocks – the series (part 2)


The second post of the series will be covering all those “small” scalability improvements in the SQL core, that help you run your workloads with even better performance just by upgrading to SQL Server 2016. The following articles are coming from the CSS SQL Server engineering team and its under the “It just runs faster” series.

SQL 2016 – It Just Runs Faster Announcement

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL 2016 – It Just Runs Faster: DBCC Extended Checks

SQL 2016 – It Just Runs Faster: Native Spatial Implementation(s)

SQL 2016 – It Just Runs Faster: TVPs with Spatial Column(s)

SQL 2016 – It Just Runs Faster: Spatial Index Builds Faster

SQL 2016 – It Just Runs Faster: -T1117 and -T1118 changes for TEMPDB and user databases

SQL 2016 – It Just Runs Faster: Automatic TEMPDB Configuration

SQL 2016 – It Just Runs Faster: LDF Stamped

SQL 2016 – It Just Runs Faster: Instant File Initialization

SQL 2016 – It Just Runs Faster: Automatic Soft NUMA

SQL 2016 – It Just Runs Faster: Updated Scheduling Algorithms

SQL 2016 – It Just Runs Faster: Dynamic Memory Object (CMemThread) Partitioning

SQL 2016 – It Just Runs Faster: SOS_RWLock Redesign

SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default

SQL 2016 – It Just Runs Faster: Larger Data File Writes

SQL 2016 – It Just Runs Faster: Multiple Log Writer Workers

SQL 2016 – It Just Runs Faster: Column Store Uses Vector Instructions (SSE/AVX)

SQL 2016 – It Just Runs Faster – BULK INSERT Uses Vector Instructions (SSE/AVX)

SQL 2016 – It Just Runs Faster: AlwaysOn Log Transport Reduced Context Switches

SQL 2016 – It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms

SQL 2016 – It Just Runs Faster – AlwaysOn AES-NI Encryption

SQL 2016 – It Just Runs Faster: In-Memory Optimized Database Worker Pool

SQL 2016 – It Just Runs Faster: XEvent Linq Reader

 

Quite a lot of improvements! Enjoy and try to keep up with with SQL 2016.

Comments (0)

Skip to main content