Category Archives: SQLServerPedia Syndication

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 SQL, SQLServerPedia Syndication | Tagged , | Leave a comment