SQL server 2016- runs a lot faster!

April 23rd, 2016 by Leave a reply »

There many well publicised features of SQL 2106 that have maybe overshadowed the many enhancements to improve performance.

Added together there is a huge impact as these various blofg articles reveal.

Large Data File Writes (April 15)
https://blogs.msdn.microsoft.com/psssql/2016/04/15/sql-2016-it-just-runs-faster-larger-data-file-writes-2/

Indirect Checkpoint Default (April 12)
https://blogs.msdn.microsoft.com/psssql/2016/04/12/sql-2016-it-just-runs-faster-indirect-checkpoint-default/

SOS_RWLock Redesign (April 7)
https://blogs.msdn.microsoft.com/psssql/2016/04/07/sql-2016-it-just-runs-faster-sos_rwlock-redesign/

Dynamic Memory Object (CMemThread) Partitioning (April 6)
https://blogs.msdn.microsoft.com/psssql/2016/04/06/sql-2016-it-just-runs-faster-dynamic-memory-object-cmemthread-partitioning/

Updated Scheduling Algorithms (April 1)
https://blogs.msdn.microsoft.com/psssql/2016/04/01/sql-2016-it-just-runs-faster-updated-scheduling-algorithms/

Automatic Soft NUMA (March 30)
https://blogs.msdn.microsoft.com/psssql/2016/03/30/sql-2016-it-just-runs-faster-automatic-soft-numa/

Instant File Initialization (March 25)
https://blogs.msdn.microsoft.com/psssql/2016/03/25/sql-2016-it-just-runs-faster-instant-file-initialization/

LDF Stamped (March 22)
https://blogs.msdn.microsoft.com/psssql/2016/03/22/sql-2016-it-just-runs-faster-ldf-stamped/

Automatic TEMPDB Configuration (March 17)
https://blogs.msdn.microsoft.com/psssql/2016/03/17/sql-2016-it-just-runs-faster-automatic-tempdb-configuration/

T1117 and T1118 Changes for TEMPDB and User Databases (March 15)
https://blogs.msdn.microsoft.com/psssql/2016/03/15/sql-2016-it-just-runs-faster-t1117-and-t1118-changes-for-tempdb-and-user-databases/

Spatial Index Builds Faster (March 10)
https://blogs.msdn.microsoft.com/psssql/2016/03/10/sql-2016-it-just-runs-faster-spatial-index-builds-faster/

TVPs with Spatial Column(s) (March 8)
https://blogs.msdn.microsoft.com/psssql/2016/03/08/sql-2016-it-just-runs-faster-tvps-with-spatial-columns/

Native Spatial Implementations (March 3)
https://blogs.msdn.microsoft.com/psssql/2016/03/03/sql-2016-it-just-runs-faster-native-spatial-implementations/

DBCC Extended Checks (March 1)
https://blogs.msdn.microsoft.com/psssql/2016/03/01/sql-2016-it-just-runs-faster-dbcc-extended-checks/

DBCC Scales 7x Better (February 25)
https://blogs.msdn.microsoft.com/psssql/2016/02/25/sql-2016-it-just-runs-faster-dbcc-scales-7x-better/

Advertisement

Comments are closed.