Sample Header Ad - 728x90

SQL Hard Drive Config?

2 votes
1 answer
691 views
I am setting up new server and am a little confused in my research of HD configuration. My main question is : 1. Is it recommended to have the Trans Logs and DB logs (ldf) on separate spindles or can they be on the same? 2. Do Trans Logs and ldf logs write concurrently or one after the other? 3. My plan is to configure it as follows: >C:\ Raid 1, >Data (Raid 10), >Logs (Trans & .ldf) Raid 10, >TempDB (Raid 1), >Local Backups (Raid 10). Does that make sense or should I separate the Trans & .ldf files onto separate raid configs ?
Asked by PBK (51 rep)
Dec 4, 2014, 05:47 PM
Last activity: Feb 15, 2023, 12:04 PM