Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've just added a new production server and I was wondering if you guys could help me decide which configuration suits best.

Current configuration:

  • 40GB ~ C (System)
  • 250GB ~ D (SQL - MDF & LDF)
  • 250GB ~ F (IIS)
  • 1TB ~ E (storage of users' files)
  • (note: C and D are partitions on the same physical HDD)

I've heard splitting LDF/MDF can do magic in terms of performance. Therefore, the core of my question is how would you recommend to do so. For example, putting the MDF with the IIS is an option, yet I'm not so sure about it.

share|improve this question

migrated from stackoverflow.com Jan 17 '11 at 22:28

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer

I've heard splitting LDF/MDF can do magic in terms of performance.

Yes. When they are on SEPARATE DRIVES. You dont split anything. Gain: zero.

I would combine F and E - IIS does not use so much (only logging). C for System, D for LDF, F for SQL.

That said, obviously all discs mirrored with a proper raid controller, bbu cache and... high performance discs.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.