Microsoft SQL Server 2014 released to manufacturing

Microsoft SQL Server 2014 released to manufacturing

Summary: Microsoft has RTM'd SQL Server 2014, which includes a new in-memory OLTP engine built jointly by Microsoft Research and the SQL Server team.

SHARE:

Microsoft released to manufacturing the latest version of its SQL Server database, SQL Server 2014, on March 18. SQL Server 2014 will be available to customers as of April 1.

sqlserver2014

The newest version of SQL Server's biggest new feature is its built-in in-memory online transaction processing (OLTP) capability, which Microsoft has said can improve database performance up to 30 times (not 30 percent -- 30 times) without any code changes to existing applications or hardware. The in-memory OLTP engine is codenamed "Hekaton." The Hekaton capabilities are designed to complement the in-memory data-warehousing and business-intelligence capabilities that are already in SQL Server.

Hekaton was developed jointly by members of Microsoft's SQL Server team, in conjunction with Microsoft Research's Database Group over the past five years.

With traditional database models, "the assumption is that data lives on disk and is stored on disk pages,” said Paul Larson, a principal researcher with MSR's Database Group, in a Microsoft-authored article about the making of Hekaton on the MSR site. “This creates a lot of overhead when you try to access records. When data lives totally in memory, we can use much, much simpler data structures. Hekaton’s index data structures and storage structures are optimized on the basis that when a table is declared memory-optimized, all of its records live in memory.”

The team working on Hekaton worked to develop new concurrency-control mechanisms to remove barriers to scalability. They moved away from a partitioned approach via which a multicore processor was treated as a distributed system, to a latch-free/lock-free design. (Latches are synchronization mechanisms designed to avoid data corruption caused when multiple users try to modify a data structure concurrently, according to Microsoft's article on Hekaton.)

Researchers in the MSR Database Group, along with those in the Communication and Storage Systems Group, also had been working on an indexing system for high-speed data access, which they referred to as the "Bw-tree." The BW-tree delivered much improved processor-cache performance, the teams discovered. That work also factored into the final SQL Server 2014 product.

SQL Server 2014 also was designed to back up more simply and seamlessly to Windows Azure, enabling users to back up their on-premises data to the cloud at an instance-level for disaster-recovery purposes. Backups can be automatic or manual, and a backup can be restored to a Windows Azure Virtual Machine, if need be.

Microsoft released a first Community Technology Preview (CTP) of SQL Server 2014 in June 2013. It released a second CTP late last year.

There's a Microsoft YouTube video with more on how Microsoft's teams created Hekaton and what it can do.

Update: If you're wondering if all SQL Server 2014 users will get the Hekaton/OLTP capabilities, the answer is no. Courtesy of reader Brian Hussey (@BLHussey), here's the chart of SQL 2014 features organized by edition. Under "Scalability and Performance," Microsoft reveals that only the Enterprise version of SQL 2014 includes Hekaton support. The Standard, BI, Web and Express SKUs do not.

Topics: Data Management, Big Data, Cloud, Microsoft

About

Mary Jo has covered the tech industry for 30 years for a variety of publications and Web sites, and is a frequent guest on radio, TV and podcasts, speaking about all things Microsoft-related. She is the author of Microsoft 2.0: How Microsoft plans to stay relevant in the post-Gates era (John Wiley & Sons, 2008).

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

5 comments
Log in or register to join the discussion
  • Did they upgrade managment studio?

    Do you know if this comes with a 2010/2013 Shell version of management studio? It would be nice to at least uninstall Visual Studio 2008 from my machine!
    moemeka
  • Did they upgrade managment studio?

    Do you know if this comes with a 2010/2013 Shell version of management studio? It would be nice to at least uninstall Visual Studio 2008 from my machine!
    moemeka
    • ?

      Have you seen SQL 2012? It has a Visual Studio 2010 engine.
      Mac_PC_FenceSitter
  • Management Studio upgraded too?

    I see this does indicate Management Studio is updated. But not sure exactly how. More info on features here: http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

    MJ
    Mary Jo Foley
    • This is generally what I like to know

      more than the actual DB upgrades, as they won't be upgrading our database servers quite so quickly.
      grayknight