SQL Server Transaction Log Fragmentation: a Primer

Posted on SQL Server Central See other posts from SQL Server Central
Published on Fri, 23 Nov 2012 07:00:00 UT Indexed on 2012/11/23 23:14 UTC
Read the original article Hit count: 273

Filed under:

Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for 'auto-grow', you can end up with such 'fragmentation' in your transaction log as to affect performance noticably. How can this be avoided? How can you tell it's a problem? What do you do about it? Greg explains.

SQL Backup Pro "SQL Backup Pro 7 improves on an already wonderful product" - Don Kolenda
Have you tried version 7 yet? Get faster, smaller, fully verified backups. Download a free trial of SQL Backup Pro 7.

© SQL Server Central or respective owner