Advertisements
Home > SQL Server 2016 > Microsoft PSS – SQL 2016 Series: It just runs faster | April updates

Microsoft PSS – SQL 2016 Series: It just runs faster | April updates


Microsoft PSS Engineers have built a series on “It Just Runs Faster”!

“In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. You can take advantage of this effort packaged in SQL Server 2016. – https://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/”

SQL 2016 will run faster in many ways, without changing code.
 

The series kickoff is here:
https://blogs.msdn.microsoft.com/psssql/2016/02/23/sql-2016-it-just-runs-faster-announcement/
 

Previous updates:
https://sqlwithmanoj.com/2016/03/28/sql-2016-series-it-just-runs-faster-feb-march-updates/
 

The announcements so far in April are:

SQL 2016 – It Just Runs Faster: Updated Scheduling Algorithms
https://blogs.msdn.microsoft.com/psssql/2016/04/01/sql-2016-it-just-runs-faster-updated-scheduling-algorithms/

SQL 2016 – It Just Runs Faster: Dynamic Memory Object (CMemThread) Partitioning
https://blogs.msdn.microsoft.com/psssql/2016/04/06/sql-2016-it-just-runs-faster-dynamic-memory-object-cmemthread-partitioning/

SQL 2016 – It Just Runs Faster: SOS_RWLock Redesign
https://blogs.msdn.microsoft.com/psssql/2016/04/07/sql-2016-it-just-runs-faster-sos_rwlock-redesign/

SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default
https://blogs.msdn.microsoft.com/psssql/2016/04/12/sql-2016-it-just-runs-faster-indirect-checkpoint-default/

SQL 2016 – It Just Runs Faster: Larger Data File Writes
https://blogs.msdn.microsoft.com/psssql/2016/04/15/sql-2016-it-just-runs-faster-larger-data-file-writes/

SQL 2016 – It Just Runs Faster: Multiple Log Writer Workers
https://blogs.msdn.microsoft.com/psssql/2016/04/19/sql-2016-it-just-runs-faster-multiple-log-writer-workers/

SQL 2016 – It Just Runs Faster: Column Store Uses Vector Instructions (SSE/AVX)
https://blogs.msdn.microsoft.com/psssql/2016/04/22/sql-2016-it-just-runs-faster-column-store-uses-vector-instructions-sseavx/

SQL 2016 – It Just Runs Faster – BULK INSERT Uses Vector Instructions (SSE/AVX)
https://blogs.msdn.microsoft.com/psssql/2016/04/27/sql-2016-it-just-runs-faster-bulk-insert-uses-vector-instructions-sseavx/

SQL 2016 – It Just Runs Faster: AlwaysOn Log Transport Reduced Context Switches
https://blogs.msdn.microsoft.com/psssql/2016/04/28/sql-2016-it-just-runs-faster-alwayson-log-transport-reduced-context-switches/

 

Check my blog posts on most of the new features released in SQL Server 2016 here
https://sqlwithmanoj.com/sql-server-2016-articles/
 


Advertisements
Categories: SQL Server 2016 Tags:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: