Perry,
Thank you so much for your response!!! Thank you so much for mentioning backups . . . cant believe i forgot to mention that. We will definitely be taking this into consideration.
One thing I still can't get a grasp on and if anyone could explain that would be great!!!
But what are the benefits seperating the arrays with their own hard drives . . . instead of seperating a big array with partitions???
Like I started to say above . . . . Example: Lets say my hard drives can do 150mb/sec READS and 150mb/sec WRITES.
Whats so wrong with having Database and Logs on one big array but seperated with partition. Like if I were using 8 drives in RAID 10 I would get 1,200mb/sec READS and 600mb/sec WRITES for my Database partition and my Log partition.
Switching to a 4 drive RAID 10 for Database will make it run at 600mb/sec READS and 300mb/sec WRITES. Plus if I go to a 2 drive RAID 1 for Logs that will have my logs run at 300mb/sec READS and 150mb/sec WRITES. Granted you are splitting it up . . . but does that really benefit much? Especially if you are dropping speed like that?
Thanks for help guys!