This is my eleventh course for Pluralsight, but the complete list of my courses is here.īuilding on this online course is a new three day class, IEUpgrade: Immersion Event on Upgrading SQL Server, taught by myself and Tim Radney. I have a new Pluralsight course, SQL Server: Upgrading and Migrating to SQL Server 2016 has just been published.
I am going to be going into more detail about this information and many other upgrade and migration subjects during the course of this series, so stay tuned! Hardware Extension Support in SQL Server 2016 I mapped some of these new features to specific processor families here:
They also added support for tail of the log caching using persistent memory (PM) in SQL Server 2016 (when running on Windows Server 2016). Microsoft did do some interesting work in SQL Server 2016 with adding support for specific processor instruction sets for some types of operations that would benefit from that support. Unfortunately, Microsoft has not chosen to invest any additional development resources in the feature in newer releases.
It is mainly interesting with SQL Server Standard Edition (due to its low memory license limit). SQL Server 2014 added a new feature called Buffer Pool Extension (BPE) that can be helpful in some scenarios with OLTP workloads. Support for new Hardware and Storage Features SQL Server 2016 Standard Edition SP1 did indirectly raise the memory limit somewhat, by adding separate pools for Columnstore indexes and for in-memory OLTP, as discussed here. Unfortunately, they did not raise the memory limit (per instance), which remains at 128GB. Microsoft raised the physical core count limit (per instance) in SQL Server 2016 Standard Edition from 16 to 24. SQL Server 2016 Enterprise Edition Performance Advantages SQL Server 2016 Service Pack 1 (SP1) released !!!Ī Big Deal: SQL Server 2016 Service Pack 1 Here are some links with more information about this: In some cases, you may also be able to go from a legacy version of SQL Server Enterprise Edition to SQL Server 2016 Standard Edition, although this may be more difficult than it seems at first due to throttling of some programmability features in Standard Edition and low SQL Server 2016 License limits for memory, sockets, and cores. This makes it more attractive and feasible for someone to upgrade from a legacy version of SQL Server Standard Edition to SQL Server 2016 Standard Edition. With the release of SQL Server 2016 Service Pack 1, many programmability features that were formerly on available in SQL Server 2016 Enterprise Edition were made available in SQL Server 2016 Standard Edition (and also in Web Edition and Express Edition). New Programmability Features in SQL Server Standard Edition Here are some of the best sources of that type of information: If you dig deeper, there are more technical blogs from Microsoft that give a lot more detail and also include additional enhancements that often are not listed in the official documentation. What’s New (Database Engine) – SQL Server 2012 What’s New (Database Engine) – SQL Server 2014 Microsoft does an uneven job of listing and fully documenting/explaining all of the new and improved features in each recent version of SQL Server, as shown in the links listed below:
This series is going to primarily cover Database Engine information, but if you are going to be using other major components, such as SSRS, SSIS, or SSAS, you will have to do additional research. It also depends of what SQL Server components you will be installing and using.
The bigger the gap, the more new features that are going to be available. For example, it makes a big difference whether you are moving from SQL Server 2005 to SQL Server 2017, or whether you are just moving from SQL Server 2014 to SQL Server 2017. It also depends on how old the legacy version of SQL Server is compared to the version you would like to upgrade to. The list of new features that might be relevant for you depends on your workload and usage scenarios.