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.

I just inherited a Server that I have to rebuild for SQL Server 2012, I was wondering what would be the best disk configuration for the database engine.

This is what I have:

  • 6 x 300GB 10k:
  • 2 x 1TB 5k:
  • 1 x 700GB PCIE SSD:

Option 1:

  • 2 x 1TB 5k with two partitions for:

    OS Data Root Directory, System Database Directory, Backup,

  • 1 x 700GB SSD for:

    User database directory, User database log directory

  • 6 x 300GB 10k disk Raid 10 with 64KB block size for:

    Temp DB Directory, Temp DB log Directory

Option 2:

  • 2 x 1TB 5k with two partitions for:

    OS Data Root Directory, System Database Directory, Backup

  • 1 x 700GB SSD for:

    User database directory

  • 4 x 300GB 10k disk Raid 10 with 64KB block size for:

    Temp DB Directory

  • 2 x 300GB 10k disk Raid 1 with 64KB block size for:

    User database log directory, Temp DB log Directory

Should I even partition the drives into multiple partitions after I provision the Raid configuration or should I just or should I use 1 partition per raid provision and just create folders in them?

This is just a standalone SQL server that will be doing a lot of change data.

Any advice would be great.

share|improve this question

closed as off-topic by RolandoMySQLDBA, Max Vernon, Michael - sqlbot, Jon Seigel, gbn Apr 30 at 7:05

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Tip of the iceberg - the question or comments reveal an underlying issue that would need extensive investigation by a consultant or database vendor support team: issues like this do not fit the SE Q&A model well. For more information see this meta post." – RolandoMySQLDBA, Michael - sqlbot, Jon Seigel
If this question can be reworded to fit the rules in the help center, please edit the question.

    
how many user databaseses do you have on this instance? what are their sizes (mdf and ldf)? –  DenisT Feb 20 at 19:22
    

Browse other questions tagged or ask your own question.