SQL Server Transaction Log Fragmentation: a Primer

来源:这里教程网 时间:2026-03-02 10:18:20 作者:

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.

[@more@]http://www.simple-talk.com/sql/database-administration/sql-server-transaction-log-fragmentation-a-primer/

相关推荐