April 26, 2010 at 4:08 am
I would like to know whether its possible to have different RAID configurations for my current database, at the moment its just a blanket RAID 10 configuration, but I'm looking to have the highly transactional databases on a RAID 10 configuration and have the static databases configured on a RAID 5 configuration.
Also, what are the best practices for creating system and log drives, my feeling is that having a blanket RAID 10 configuration isnt ideal if the load on the disks isnt spread across all the disks. If one has a storage array with 300GB x 20 disks on a RAID 10, which is 6TB raw capacity and 3TB with a RAID 10 configuration, my environment has both production and development systems, the question I have is that, is it better to create LUNS on the entire disks, and split it into two, so 1.5TB each for both development and production.
OR
split the disk groups into two tiers TIER 1 (300GB x 10) and TIER 2 (300GB x 10), then have RAID 10 configuration on the two sets of disks.
Another question I have is that, is it best practice to have mixed RAID configurations for the disks, such that a (3 x 300GB) partition can be created with a RAID 5 configuration with 600GB space capacity. or in other words, given a 20 x 300GB disk set, how would you configure the disk IO for performance, the configuration has to be mirrored for both production and development. I would also need different LUNs for transaction logs, system databases and also user databases.
Ideas please.
April 26, 2010 at 8:11 am
Any ideas guys.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply