Post reply

Splitting ldf and mdf onto seperate disk LUNS

  • June 3, 2014 at 10:50 am

    #1718604

    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

    #1718666

    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

    #1718678

    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 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply