Dear list,
We had an engagement with the SeeFusion folks a few months ago (6?) in
which they made some recommendations to us regarding a new SQL Server
box. I'm not sure if our hosting company did what they recommended (I
was not involved in that part of the engagement) but here's what we've
got now.
The server has 4x146gb scsi drives set up in 2 RAID-1 mirrored sets.
We ended up with a 20 gig C drive and a 120gb D: drive on one mirrored
set, and 70 gig E: and F: drives on the other mirrored set. Currently
we've got our SQL Server data files on the D: drive, the transaction
logs on the E: drive, and the backups on the F: drive.
The database is relatively small (7gb) but used pretty heavily..
I have the ability to add four more drives to the machine... I'm
thinking of adding 4x73gb (15k rpm) in a RAID5 set with two partitions
on it.. one maybe 50gb for the sql data files, and the rest for
storing backups... then I will truly have my OS, data, and transaction
logs all on separate drive sets.
Seem reasonable? Other Suggestions?
--
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320341
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
