#transaction logs

[seniordba]

Transaction Log File Size and VLF in SQL Server

Transaction Log File Size and VLF in SQL Server

This article by Kimberly Tripp is very interesting. Simply put, she says you want the initial size of your transaction logs set to 8 GB, with auto growth set to 8 GB. This should help keep your Virtual Lof File (VLF) sizes below 512 MB, improve performance, and make maintenance during backups much faster.

The article, in part, reads:

First, here’s how the log is divided into VLFs. Each “chunk”…

View On WordPress

[seniordba]

Transaction Log File and VLF Size

Transaction Log File and VLF Size

This article by Kimberly Tripp is very interesting. Simply put, she says you want the initial size of your transaction logs set to 8 GB, with auto growth set to 8 GB. This should help keep your Virtual Log File (VLF) sizes below 512 MB, improve performance, and make maintenance during backups much faster.

The article, in part, reads:

First, here’s how the log is divided into VLFs. Each “chunk”…

View On WordPress