Book Image

Applied Architecture Patterns on the Microsoft Platform

Book Image

Applied Architecture Patterns on the Microsoft Platform

Overview of this book

Table of Contents (20 chapters)
Applied Architecture Patterns on the Microsoft Platform Second Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

New features of SQL Server 2014


To conclude this chapter, let's take a look at what the Community Technology Preview 2 (CTP 2) of SQL Server 2014 presents us with. The commercial release of SQL Server 2014 will most likely happen in early 2014.

So far, the following new features of SQL Server 2014 have been revealed:

  • Enhanced In-Memory OLTP that gains significant performance by moving the most-used tables into memory. According to Microsoft, the performance gains will average 10 times and can even reach 30 times. This is achieved via a new engine with a code name Hekaton.

  • In SQL Server 2012, Resource Governor allowed you to adjust the amount of CPU and memory resources, but with SQL Server 2014 IO Resource Governor, we can manage and limit the I/O utilization. That enables more effective I/O management across multiple databases.

  • Improved resilience with Windows Server 2012 R2 using Cluster Shared Volumes.

  • The Buffer Pool Extension (BPE) feature that enables caching frequently used data on Solid...