Fragmented Log files could be slowing down your database
- by Fatherjack
Something that is sometimes forgotten by a lot of DBAs is the fact that database log files get fragmented in the same way that you get fragmentation in a data file. The cause is very different but the effect is the same – too much effort reading and writing data.
Data files get fragmented as data is changed through normal system activity, INSERTs,…