Mar 7, 2016 · Databases

How SQL Server Hekaton Supercharges OLTP with In‑Memory, Latch‑Free Architecture

This article examines the performance bottlenecks of traditional relational databases, explains how SQL Server 2014's In‑Memory OLTP (Hekaton) uses latch‑free Bw‑tree structures, optimistic timestamp‑based concurrency, and native compilation to achieve orders‑of‑magnitude speedups, and discusses its practical limits and real‑world case studies.

Database PerformanceHekatonIn-Memory OLTP

0 likes · 20 min read

How SQL Server Hekaton Supercharges OLTP with In‑Memory, Latch‑Free Architecture

ITPUB

Jan 23, 2015 · Databases

Inside Yiche’s SQL Server: Memory DB, HA, Cloud and Performance Secrets

In this technical interview, Yiche Group’s senior DBA Gao Jiwei shares how the company designs its database platform, leverages SQL Server’s in‑memory OLTP, implements high‑availability solutions, builds a private cloud with open‑source tools, and optimizes performance during massive traffic events.

In-Memory OLTPSQL Serverperformance tuning

0 likes · 16 min read

Inside Yiche’s SQL Server: Memory DB, HA, Cloud and Performance Secrets