Proper placement of Database files

  • A separate array helps, but only during backups. You don't have heads moving for two separate processes. Not sure how noticeable it would be.

    However it's a bad idea. If the array dies, how do you recover? Don't put your backups with your data. fundamentally not a smart thing.

  • More important than the backups, it sounds like you have the log files on the same array as the data files. Is that correct? If so, you'll want to split that up and separate them.

    Edit: Clarification: More important for performance, not necessarily for data loss prevention. Important for that, too.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 3 (of 3 total)

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