• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Database Server RAID Setup

Manu

Limp Gawd
Joined
Mar 3, 2003
Messages
203
Hey everyone, I am purchasing a new DB server for a disk intensive/cpu heavy database. My main questions are with the storage controllers and RAID setup.

This is my current thought:

RAID 0/1 36GB 15K SAS - OS and programs
RAID 0/1 72GB 15K SAS - main data
RAID 10 72GB 15K SAS - trans table (main table, most IO) from DB

What are your thoughts? Should I be looking at a dedicated controller for the RAID 10 and put the other RAIDs on a different one?

Any suggestions or recommendations would be very helpful.

Thanks,
Manu
 
Which DB Server? (MS SQL, MySQL, Oracle, etc) What size DBs? How many transactions per day?
 
When buying your server take a close look at which riser card and which back plane card you buy. It could impact the speed as well.
 
We're going to be upgrading from SQL 2000 to SQL 2005. The DB is actually really small, about 3.5GB, but it is a very poorly organized DB that tosses almost all data into a single table...
 
Back
Top