SQL Server – Performance – Log file

Logfile hardware recommendations. By Tripp.

4) Not only should you try to isolate the transaction log to its own physical disk but you should make sure that the logical/physical disk configuration is as efficient as possible. 
   Try to use an isolated RAID 1 mirroring set if you don't need significant capacity. If you need a greater capacity OR you want better performance, 
   consider a combination of RAID 0 and RAID 1 (either RAID 0 + 1 or RAID 1 + 0). 
While RAID 0 + 1 can often offer better performance, RAID 1 + 0 offers better reliability.

RAID specifics.

Comments are closed.

Post Navigation