Microsoft SQL Server 2014 Neighborhood Expertise Preview 1 (CTP1) is able to obtain

SQL server 2014 Neighborhood Expertise Preview 1 (CTP1) is able to obtain right here: http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx

Mission code-named “Hekaton”

Some of the thrilling options on this model is a undertaking code-named “Hekaton” that gives in-memory OLTP capabilities. As Hekaton is constructed into core SQL Server database it would enhance the efficiency of the database functions considerably. It’s extra attention-grabbing that Hekaton is put in with SQL Server 2014 engine meaning no extra motion is required to make use of the advantages of in-memory processing with out rewriting the database utility. It’s actually superior that it may well improve efficiency of current database utility with out having to improve the {hardware}. Microsoft claims that Hekaton is straightforward to deploy and permits to entry the opposite options in SQL Server, whereas taking the benefit of in-memory efficiency.

xVelocity ColumnStore

xVelocity ColumnStore supplies the power of in-memory processing for information warehouses. So utilizing it in an information warehouse can enhance question efficiency, load pace, scan fee and cut back useful resource utilization like much less disk and fewer reminiscence.

Microsoft claims that “The brand new ColumnStore enhances the present xVelocity ColumnStore Index, offering greater compression, richer question help and updateability of the ColumnStore providing you with the even quicker load pace, question efficiency, concurrency, and even cheaper price per terabyte.” I actually just like the “cheaper price per terabyte” half!

Extending Reminiscence to SSDs

The first goal of a database likewise SQL Server database is to retailer and retrieve information, so the quicker disk I/O the higher efficiency. And since disk I/O operations are consuming plenty of sources and taking related time to be accomplished, SQL Server must concentrate on making I/O as environment friendly as potential. So buffer administration is a key part to achieve to the I/O effectivity aim. Buffer administration consists of managing the buffer to entry and replace database pages and the buffer pool (referred to as buffer cache additionally) to scale back database file I/O. Microsoft claims that SQL Server 2014 “Seamlessly and transparently integrates solid-state storage into SQL Server by utilizing SSDs as an extension to the database buffer pool, permitting extra in-memory processing and lowering disk IO.” and it appears to be an ideal function.

Enhanced Excessive Availability

New AlwaysOn options

Availability Teams now help as much as 8 secondary replicas that stay out there for reads always, even within the presence of community failures. Failover Cluster Cases now help Home windows Cluster Shared Volumes, bettering the utilization of shared storage and growing failover resiliency. Lastly, varied supportability enhancements make AlwaysOn simpler to make use of.

Improved On-line Database Operations

Contains single partition on-line index rebuild and managing lock precedence for desk partition swap, tremendously growing enterprise utility availability by lowering upkeep downtime affect.

There needs to be some extra nice options in SQL Server 2014 that we’ll talk about about them extra sooner or later.