Episode

How To: Creating a Persistent Log Buffer in SQL 2019

Data Exposed

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

  • [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