sql server 2014: what's vnew for vnext
DESCRIPTION
SQL Server 2014 is here! Well…almost here, as there is no official release date yet. One thing is certain about SQL 2014: Microsoft is taking steps towards building a true hybrid database platform. The integration with Windows Azure stands out to me as a more notable enhancement than many of the database engine enhancements. The following slides highlight some of the most notable features that are expected to be available in SQL 2014, also sometimes referred to as “vNext”.TRANSCRIPT
1
SQL Server 2014: What’s vNew for vNext
Thomas LaRockTechnical Evangelist and Senior DBA
Confio Software
http://www.confio.comWednesday, April 12, 2023
Wednesday, April 12, 2023 2
Introduction
SQL Server 2014 is here! Well…almost here, as there is no official release date yet.
One thing is certain about SQL 2014: Microsoft is taking steps towards building a true hybrid database platform. The integration with Windows Azure stands out to me as a more notable enhancement than many of the database engine enhancements.
The following slides highlight some of the most notable features that are expected to be available in SQL 2014, also sometimes referred to as “vNext”.
http://www.confio.com
3
Hekaton
SQL Server 2014 will offer a true in-memory OLTP engine (former code name “Hekaton”).
Users will be able to decide which tables will be stored in memory. Unlike the PINTABLE command from previous versions, Hekaton will use a new multiversion concurrency control (MVCC) method in order to process data without any latching, locking, or blocking. Say goodbye to your old friend PAGEIOLATCH!
Early adopters are seeing 7x improvement without any code changes (other than declaring a table to be stored as a Hekaton table). Users will also be able to compile stored procedures into machine code for additional performance gains.
http://www.confio.comWednesday, April 12, 2023
4
To The Cloud!
SQL Server 2014 will offer users more integration with Windows Azure.
Users will be able to take a backup of a database and save it to an Azure storage account by pointing to a URL. There is also the Smart Backup feature, allowing SQL Server to decide if it is time to take a differential or transaction log backup.
Users will also be able to create a database in an on-premises instance, but have the data and log files reside in Azure.
Users will also be able to extend an AlwaysOn Availability Group by creating replicas stored in a virtual machine running in Windows Azure.
http://www.confio.comWednesday, April 12, 2023
5
SSD Memory Caching
SQL Server 2014 will allow users to extend their memory storage to SSD cards (or even an array).
This will allow those users that have a mixed-use system (i.e., an OLTP system that is being hit hard for reporting) to cache clean pages inside of SSD storage.
http://www.confio.comWednesday, April 12, 2023
6
General Enhancements
SQL Server 2014 offers many enhancements to existing features.
Tables using Columnstore indexes will now be updateable.
Resource Governor will allow for throttling I/O in addition to memory and CPU.
Statistics are available at the partition level, and the cardinality estimator has been improved as well.
Enhanced separation of duties, allowing for a DBA to do admin tasks and not be allowed to see sensitive data.
Additional ONLINE maintenance operations (i.e., rebuild a single partition index) are available.
http://www.confio.com
7
When Can We Get The Bits?
SQL Server 2014 is expected to release a preview in June of 2013, and is scheduled to be released for general availability in early 2014.
http://www.confio.comWednesday, April 12, 2023
Wednesday, April 12, 2023 8
Summary
SQL Server 2014 will mark a major shift in database technology. I expect other major database platforms to follow suit with Cloud integration.
Worth noting here is the ability for Microsoft to turn around major enhancements in less than 18 months from the last major release (SQL Server 2012).
I expect that we are going to see this trend continue, with major releases being delivered in shorter timeframes going forward.
http://www.confio.com
9
For More Information
• http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/04/edgenet-gain-real-time-access-to-retail-product-data-with-in-memory-technology.aspx
• http://download.microsoft.com/download/D/7/D/D7D64E12-C8E5-4A8C-A104-C945C188FA99/SQL_Server_2014_Datasheet.pdf
http://www.confio.comWednesday, April 12, 2023
Wednesday, April 12, 2023 10
For Even More Information
• For help with database performance go to http://www.confio.com
• For more information on WASD you can check my blog at http://thomaslarock.com/category/sql-azure/
http://www.confio.com