ITPub博客

首页 > 数据库 > SQL Server > SQL Server Transaction Log Fragmentation: a Primer

SQL Server Transaction Log Fragmentation: a Primer

原创 SQL Server 作者:kitesky 时间:2012-12-18 17:39:47 0 删除 编辑

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/

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/66009/viewspace-1059942/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-04-22

  • 博文量
    273
  • 访问量
    2163776