wildcard00
New Member
Hello everyone,
We just recently purchased an EMC Clariion FC4700 storage system. The storage system consists of 10x 146GB drives and 10x 73GB drives for a total of 2.2 TB of disk space. This is obviously overkill for our Progress 8 database size of 100GB. We are debating two options as far as LUN setup....
Our database sizes are as follows:
Loans 14,663,586,816 *
Focus 37,670,542,336 *
Taxes 24,504,373,248 *
Taxcert 7,716,995,075
Textax 6,775,717,888
NTN 4,929,847,296
SRI 983,031,808
Imaging 983,037,952
1) 4x 73GB drives -- LUN 0, RAID 10 (Focus)
4x 73GB drives -- LUN 1, RAID 10 (Loans)
2x 73GB drives -- LUN 2, RAID 1 (Imaging)
4x 146GB drives -- LUN 3, RAID 10 (Taxes)
4x 146GB drives -- LUN 4, RAID 10 (Everything else)
2x 146GB drives -- LUN 5, HOT SPARES
2) Mirror all database extents on separate drives
Option 1 is the most efficient in terms of performance, but is also very wasteful in disk space usage since none of our database extents will ever come close to filling the size of any of those LUN's.
Option 2 is the most space efficient without turning the whole thing into a JBOD, but lacks the performance increase.
My final question is if we place two or more database extents on a RAID 10 LUN, would that be the same as placing only one database extent on a RAID 1 LUN in terms of performance? If not, how big is the performance gap? negligible or noticeably large? I ask this because it would save us quite a bit of space if we knew that placing multiple database extents on one RAID 10 LUN yielded the same performance numbers as placing one database extent on a RAID 1 LUN. Any feedback would be welcome. Thank you.
Tony
We just recently purchased an EMC Clariion FC4700 storage system. The storage system consists of 10x 146GB drives and 10x 73GB drives for a total of 2.2 TB of disk space. This is obviously overkill for our Progress 8 database size of 100GB. We are debating two options as far as LUN setup....
Our database sizes are as follows:
Loans 14,663,586,816 *
Focus 37,670,542,336 *
Taxes 24,504,373,248 *
Taxcert 7,716,995,075
Textax 6,775,717,888
NTN 4,929,847,296
SRI 983,031,808
Imaging 983,037,952
1) 4x 73GB drives -- LUN 0, RAID 10 (Focus)
4x 73GB drives -- LUN 1, RAID 10 (Loans)
2x 73GB drives -- LUN 2, RAID 1 (Imaging)
4x 146GB drives -- LUN 3, RAID 10 (Taxes)
4x 146GB drives -- LUN 4, RAID 10 (Everything else)
2x 146GB drives -- LUN 5, HOT SPARES
2) Mirror all database extents on separate drives
Option 1 is the most efficient in terms of performance, but is also very wasteful in disk space usage since none of our database extents will ever come close to filling the size of any of those LUN's.
Option 2 is the most space efficient without turning the whole thing into a JBOD, but lacks the performance increase.
My final question is if we place two or more database extents on a RAID 10 LUN, would that be the same as placing only one database extent on a RAID 1 LUN in terms of performance? If not, how big is the performance gap? negligible or noticeably large? I ask this because it would save us quite a bit of space if we knew that placing multiple database extents on one RAID 10 LUN yielded the same performance numbers as placing one database extent on a RAID 1 LUN. Any feedback would be welcome. Thank you.
Tony