Optimizing Transaction Log Throughput
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Tue, 27 May 2014 06:00:00 UT
Indexed on
2014/05/27
9:44 UTC
Read the original article
Hit count: 108
Filed under:
As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. This article demonstrates how this can have a significant impact on the performance of any SQL Server operations that need to read the log.
© SQL Server Central or respective owner
