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.