How OLTP can be improved with SQL server 2014 In-memory?

How OLTP can be improved with SQL server 2014 In-memory?

InMemory_OLTP_SQL_Server_2014There has been a lot of talk recently around the in-memory databases, and quite justifiably so. The user requests served from memory are processed at a lightning fast speed necessitating a robust in-memory database that can easily carry out complex transactions quickly, increasing the business productivity manifold.

The new SQL server 2014 pushes the boundaries with dramatic performance, cloud capabilities and the rapid delivery to the customers. The world around is changing with the customers storing and collecting more data, demanding more from their data, and seeking the value of new insights for their business, driving technology to push the boundaries.

A new feature in the SQL server 2014, In-memory OLTP makes significant improvements in the performance of OLTP database applications on a server. It is a database engine optimized for memory that integrates seamlessly into the mainline SQL server engine, which is comprehensively optimized for OLTP.

In-Memory OLTP is largely impelled by the evolutionary trends in the entire computing landscape marked by three key factors:

  • Marked reduction in the overhead costs of Memory
  • Computing cores have substantially increased
  • The native speed of CPUs todays has more or less flattened

The key features of in-memory OLTP include memory-optimized tables and table types, as well as native compilation of Transact-SQL stored procedures to access these tables efficiently. The In-memory OLTP engine employs memory-optimized tables that can be optimized to for a lasting performance.

In-Memory OLTP is fully integrated with SQL server in order to provide a flawless experience in all areas such as development, deployment, support and management.  A database can house both in-memory and disk-based objects for the optimum performance across the board. Rows in memory-optimized tables are compartmentalized and versioned accordingly, thereby making each row in the table have multiple versions.

SQL server in-memory OLTP shows dramatic improvement in the performance of a typical system and provides sufficient insights to business users to select which business objects should be placed in-memory, based on varied contingencies.

In-Memory OLTP helps in achieving significant performance and scalability gains by using:

  • Specific algorithms that are optimized for accessing memory-resident data.
  • Positive concurrency control that obviates logical locks.
  • Lock free objects that preclude all physical locks and latches.
  • Natively compiled stored procedures, which provide markedly better performance than interpreted stored procedures, while accessing a memory-optimized table.

In-Memory OLTP engine can provide up to 30 times OLTP performance gains and up to 90% disk space savings.

Tags:
  • In-Memory OLTP,
  • in-memory OLTP engine,
  • OLTP database application,
  • OLTP engine,
  • OLTP Performance,
  • sql server 2014,
  • Leave a Reply