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
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 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