Thursday, May 24, 2007

Transaction Log Optimization

* Pre-allocate the log to appropriate size

* Minimize auto growths

* Log might NOT show 0 Percent Log Used after backup for example - the % Log Used will be ~6%

* Disk Bound Systems might experience some performance degradation at log backup

* Consider RAID 1+0 instead of RAID 1, RAID 5 generally is not recommended

* Optimize existing file – minimize VLFs

- - -

source : SQL Server Community In touch

No comments: