SQL Server Transaction Log Fragmentation: a Primer

kitesky發表於2012-12-18
SQLServerFragment

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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/66009/viewspace-1059942/，如需轉載，請註明出處，否則將追究法律責任。

相關文章