General discussion


Optimal disk config for database server

By bojten ·
I am hoping to get some answers and ideas from you guys regarding on what to choose.

What to think of when purchasing disks to a database server?
Required storage: 600GB - 1.4 TB (depending on installation size) // DB design requires quite a lot of data to be transferred between DBs and tables
What disk speed should be used? (10K rpm or 15K rpm?)
RAID solution? What to prefer to ensure optimal performance.

To go further.. should I mix RAID config and sets to put temp db on single physical disk?
i.e. RAID5 for customer DB and RAID 1+0 for TEMP DB.

What are your thoughts?

Nicolaj Aaroe

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Safety First

by csmith In reply to Optimal disk config for d ...

For customer databases, safety is always the first priority.
Hardware is so cheap compared to the value of the data that its cost is of almost no consideration. Speed is also secondary to safety.
So, yes a minimum of RAID 5 for the database, and if more speed is required, put the temporary files on a secondary array on a seperate controller, that is on a different interrupt.
Regards, Chris

Collapse -

Always RAID 5

by csmith In reply to Safety First

I am a bit more conservative.
When dealing with hardware for databases, minimum of RAID 5, and offsite backup.
The minimum of RAID 5 for the image of the business to the customers, and the efficency of the business.
Offsite backup for the survival of the business.
Every business, I have seen, that lost its' database went bankrupt within six months.

Another reason for using RAID 5 on the OS as well is:
When you are dealing with small businesses; you hve to consider what comes later.
Sometimes inexperienced users will load additional software into the server,
and they will usually load it onto the drive with the OS.
When something goes wrong, of course, they will try to blame you and the hardware.
There must be no problem in the hardware.

This also goes for the drive speed.
Only install drives that the cooling can support.
I have made the mistake of installing drives with high power dissapations that the case could not cool.
Resulted in a call back, and lots of exra work and costs.
Regards, Chris

Collapse -

My config would be

by cmiller5400 In reply to Optimal disk config for d ...

RAID1 array (2 disks) for OS
RAID5 Array (min of 3 disks) for DB files
RAID5 Array (min of 3 disks) for DB transaction log files/ TempDB

Go with the 15K drives and make sure that each RAID array is on it's own controller for optimal performance. Extreme overkill for a small database, but with a very large DB with zillions of writes, it would be better to have a controller per RAID array.

It has been a while since I read up on SQL server and had to administer it day to day, so hopefully someone will be by with more tips.

Related Discussions

Related Forums