• 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.

How would you build this serious SQL server?

Z

ZROUT

Limp Gawd
Joined
Jan 15, 2003
Messages
178
I know what I want, but I'm not exactly sure how I will put it together yet. I have limited experience with several different RAID setups in the same system.

I would need a dual xeon box with 12 hard drives split into these categories.

RAID 1 for OS and applications - 2 drives
RAID 1 for SQL database log files - 2 disks
RAID 5 for SQL data files - 4 disks
RAID 1 for temporary db - 2 disks
RAID 0 for SQL backups - 2 disks

would I need 3 different raid controller cards? what hardware would fit the specs? how about general thoughts on this setup... like/dislike?

thanks
 
I would recomend a external system that has its own raid controllers. It will be more reliable and easier to setup and upgrade.

Something like this

http://products.gateway.com/products/gconfig/prodseries.asp?seg=cp&gcseries=gtwy840


That box is actually made by www.nstor.com you should be able to find it cheaper some where else.

I would recomend keepping the OS and applications on a single scsi disk inside the server. Everything else in an outside enclosure. Make the temporary DB a raid0, and make the SQL back ups a raid5. That would be a very good performance and reliablity setup.
 
If this is a serious server consider the following:

RAID 1 for OS and applications - 2 drives
RAID 10 for SQL database log files - 4 disks
RAID 10 for SQL data files - 4 disks
RAID 1 for temporary db - 2 disks
RAID 1 for SQL backups - 2 disks

Though you could have the OS and the Temporary share the same drives, and even the backups too if you have the space.. But I am assuming this is just for maintanence backups.. you actual data backups for disaster recovery will be off site on another media right?

RAID 10 is the fastest for Databases, and you want your DB and Log files to be fast...

You could also use RAID5 for the other three (esp if they are going to share drives). so:

RAID 5 for OS,temporary db,SQL backups and applications - 3 drives (or 4 if you want hot spare)
RAID 10 for SQL database log files - 4 disks
RAID 10 for SQL data files - 4 disks


==>Lazn
 
Off of the Microsoft web site, they suggest splitting the volumes like this:

Vol1: OS
Vol2: MSSQL Programs + system databases
Vol3: Application db data file(s)
Vol4: Application db log file(s)

In your case, add:

Vol5: SQL backups.

Use Raid-1 and RAID-10 as above.

A good, quick resource on SQL server setups:

http://www.sql-server-performance.com/sql_server_setup.asp
 
You must log in or register to reply here.
Back
Top