Friday, August 09, 2013

"How the heck is Hekaton part of SQL Server 2014..." More on SQL Server 2014's In-Memory Tech

SQL Server Blog - How Memory-Optimized Database Technology is Integrated into SQL Server 2014

SQL Server 2014 takes an integrated approach to in-memory database technology. In-Memory OLTP, which optimizes performance of OLTP workloads, is fully integrated in the core SQL Server relational database management system.

Now, what do we mean by “fully integrated”? In this post we highlight some of the aspects that demonstrate:


No special steps are needed to install In-Memory OLTP. Simply install the SQL Server 2014 Database Engine Services, and In-Memory OLTP will be available, provided you install an edition of SQL Server that supports the feature. The In-Memory OLTP components are part of the database engine services, and run as part of the sqlserver.exe process.


The same SQL Server database can have both traditional disk-based and the new memory-optimized tables. This means the size of the database is not restricted by the available memory. To optimize the performance of a database application, only the frequently accessed “hot” part of the data needs to be memory-optimized; the remainder can stay on disk.


In-Memory OLTP adds new memory-optimized tables for optimized in-memory storage, and natively compiled stored procedures for speeding up business logic execution. You can use the familiar Transact-SQL language, which we extended to mark specific tables as memory-optimized and to make stored procedures as natively compiled. For examples, see our post on Getting Started with In-Memory OLTP.


Transactions and Logging

Memory-optimized tables and natively compiled stored procedures are fully transactional, like the traditional tables and stored procedures in SQL Server. Transactions on memory-optimized tables provide the usual ACID guarantees: ...

Storage and Availability

In-Memory OLTP introduces a new type of filegroup (MEMORY_OPTIMIZED_DATA) for persistence of the data in memory-optimized tables. This filegroup is used during database startup to recover the data in the memory-optimized tables.


Familiar Tools and Client Connectivity

Memory-optimized tables and natively compiled stored procedures can be accessed and managed using the same tools as you would for traditional tables and procedures. For example, you can use Management Studio to manage the database and issue ad hoc queries, and use Integration Services to load data.


Nice high level view of how Hekaton is integrated/part of/bundled in/etc. SQL Server 2014


Related Past Post XRef:
Can you Hekaton? Intro to the SQL Server 2014 Analysis, Migration and Reporting tool...
Playing with SQL Server 2014 (and VS2013) the Azure VM way
"Microsoft SQL Server 2014 CTP1 Product Guide" - One new SQL Server, 12 PDF's...
Dev:"But it's new and shinny! Let's upgrade!" DBA:"Over my..." - Preparing to upgrade your SQL Server
TechEd NA 2013 Day 1 Announcement Round-up - VS 2013, TFS 2013, InRelease, SQL 2014, Server 2012 R2, BizTalk Services, Azure-in-a-box and even more Azure...


No comments: