sql server 2016

SQL Server

How To Create a Persistent Log Buffer in SQL 2019

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. [00:00] Intro [00:45] Positioning persistent log buffer [01:13] Persistent […]

Read More