Database Architecture

[John]

We have database thats transaction intensive, so we are trying to sepetrare ldf file from mdf file to a different disk array. what raid should I use for the Transactional log file(.ldf).

Thank You,
John

[Simon]

John,

If you can afford it, use Raid 10, else use Raid 1.

The transaction log is write intensive. Raid 5 has 4 IOs for each write, Raid 10 and Raid 1 have 2 but Raid 10 has the advantage of being scalable whereas Raid 1 is limited to 2 drives.

The other important thing to note is that writes to the transaction log are sequential. If you have more than one database, put each log on each own drive if possible.


------------
John at 1/22/01 6:06:40 PM

We have database thats transaction intensive, so we are trying to sepetrare ldf file from mdf file to a different disk array. what raid should I use for the Transactional log file(.ldf).

Thank You,
John