Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

First think : MDF and LDF separate on raid 1 Second think : All in one raid5.

share|improve this question
    
ou don't need a seperate raid for the LDF, if your database is rarely updated. All other suggestions would depend on your data and usage, but you don't provide any informations. –  edze Nov 23 '12 at 8:35
    
Could you elaborate on your question a bit? One can guess what you want to ask here, but I'm sure you'd get better answers to a better question. A bit of information about your disk array would be useful for sure. Knowing the typical load of it is often handy. –  dezso Nov 23 '12 at 9:21
3  
read/write ratio? Size of data/RAM ratio? OLTP, DW or BI workload type? Frequency and size of writes? Any secondary log reading workload (replication, DBM)? –  Remus Rusanu Nov 23 '12 at 9:53
add comment

closed as not a real question by Marian, RolandoMySQLDBA, Paul White, Mark Storey-Smith, Derek Downey Nov 26 '12 at 14:45

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

Depends on what it is be used for really. For lots of writes I would look at raid 1 or 10 not raid 5 which would be used for lots reads (reporting). Unless you have a relatively new SAN then 5 would be ok due to better caching.

A different Physical disc for data and log files if you can. ALWAYS keep backups on a different disk to the data files this should be RAID 5.

As much Ram as you can get.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.