June 3, 2014 at 9:16 am
Hi all,
Very quick question (i hope), asides from the obvious performance benefits of spliting ldf and mdf files onto seperate disk LUNS are there any other benefits of this design.
One i can think of is if a database is using FULL recovery the transaction log can still be used for recovery if the drive holding the database files is lost but the drive for the transaction log is still available.
Does anybody have any other benefits ?
Many thanks
Frant101
June 3, 2014 at 10:50 am
You can use different RAID levels for data vs logs. Data often does best with RAID5, whereas logs often do best with RAID10.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 3, 2014 at 1:24 pm
Hi,
Many thanks for the response,
Yeah I understand the need for splitting out ldf and mdf files for performance benefits but was looking at it more from an SQL Server operational aspect. i.e Recovery benefits
Many thanks
Frant
June 3, 2014 at 1:47 pm
OK, sorry. I guess I interpreted "any other benefits" too broadly.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply