How To: Creating a Persistent Log Buffer in SQL 2019 | Data Exposed

From the creator

Persistent Log Buffers, sometimes referred to as tail of log caching, uses persistent memory to persist the database log buffer, eliminating bottlenecks that may occur on busy systems waiting for the log buffer to flush to disk. A process known as log hardening. Learn more here: https://docs.microsoft.com/en-us/sql/relational-databases/databases/add-persisted-log-buffer?view=sql-server-ver15&WT.mc_id=dataexposed-c9-niner [00:00] Intro [00:45] Positioning persistent log buffer [01:13] Persistent memory (PMEM) devices [01:58] Usecase for and benefits of persistent log buffer [02:31] Best practices for SQL Server with PMEM in Windows [03:38] Best practices for SQL Server with PMEM in Linux [04:01] What is persistent log buffer? [04:43] What is forced delayed durability? [05:30] Difference between persistent log buffer and forced delayed durability [06:42] Demo: setting up persistent log buffer [07:54] Wrap-up Follow Brian Carrig and Jeroen ter Heerdt on Twitter at https://twitter.com/briancarrig and https://twitter.com/jeroenterheerdt. More Data Exposed: https://www.youtube.com/playlist?list=PLlrxD0HtieHieV7Jls72yFPSKyGqycbZR&WT.mc_id=dataexposed-c9-niner

Published 2020-02-18 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.