Tag Archives: In-Memory

In-Memory logging and log “compression”

Introduced with SQL Server 2014, In-Memory OLTP (IMOLTP) provided a new optimistic concurrency model which implemented a lockless and latchless mechanism resulting in far better throughput for short concurrent OLTP workloads. Unlike the traditional on-disk concurrency model, IMOLTP stores table … Continue reading

Posted in Database, SQLServerPedia Syndication | Tagged , ,