The SQL Server Transaction Log, Part 2: Log Architecture
SQL Performance
FEBRUARY 1, 2022
Everything else I’ll cover in the series requires knowing some of the architecture of the transaction log, so that’s what I’m going to discuss this time. You can’t specify how many VLFs are created by SQL Server when the database is first created or the log file automatically grows, but you can influence it.
Let's personalize your content