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.

We are building a new server at work and I'm hoping to get ideas of how we should build it out for optimum performance and back-up capability. We have 6 drives and we need to have an OS (Windows Server 2008) and DB (SQL Server 2010). Everything is brand new, 6 x 146GB disk drives, 2 AMD 2.2Ghz Quad processors and 16GB of memory.

We have a program that continuously reads and writes to a SQL Database.

share|improve this question
    
probably a better fit for database administration or server administration site –  Stuart Ainsworth Nov 30 '11 at 0:35
1  
you sure it's SQL 2010? You mean 2008 R2? –  SqlSandwiches Nov 30 '11 at 3:23
2  
tell us more about the database. How big, how many users, how many transactions per second, etc. –  mrdenny Nov 30 '11 at 4:36
add comment

migrated from stackoverflow.com Nov 30 '11 at 1:02

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

2 Answers

The only option to think about is disk layout but you only have six of them.
This isn't enough for "optimum performance"

  • A RAID 1 volume with 2 disks will be around 135GB so if your database is 100GB+ you'd need RAID5/RAID 10 with 4 disks, but then you don't have enough for separate logs/OS/Tempdb volumes. As an aside, with 100GB+ DB why only 16GB RAM? (this will be 12GB for SQL Server cache)

  • If you have high write volumes then you'd need a separate log drive, again RAID 1.

  • Tempdb is best with it's own volumes too. And OS/binaries. And local backup unless you have a fast network to backup to.

But, with just 6 disks I'd go for a single RAID 10 using all 6 disks as per this question:
Help me choose a RAID level combination for a SQL Server 2008 instance

With more disks then you can consider something discussed here:
SQL Server configuration / specification recommendations and advice!

Note, these are not strict rules: it depends on your database load and sizes

Optimum and cheap don't go together when buying servers...

share|improve this answer
add comment

So far (I'll update this as you provide more info).

2 disk RAID 1 for the OS, 2 disk RAID 1 for the data, 2 disk RAID 1 for the transaction logs.

These are the kinds of questions you should be asking before you purchase hardware.

share|improve this answer
add comment

Your Answer

 
discard

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