Memory-optimized Logging

In a previous post I talked about transaction log works, and what about using a memory-optimized table? SQL Server has the feature Memory-Optimized Objects to improve performance. In-memory nonclustered indexes are implemented using a data structure called a Bw-Tree. A Bw-Tree is a lock and latch-free variation of a B-Tree. In-memory architecture: To enable an … Continue reading Memory-optimized Logging

Logging

Every database has a transaction log that records all transactions and the database modifications made by each transaction The transaction log is a critical component of the database. If there is a system failure, you will need that log to bring your database back to a consistent state. How that works? What steps SQL Server … Continue reading Logging