We are migrating to V9 from V8.3c.
The benefit of storage areas seems to be that certain high I/O tables can be seperated from other parts of the database.
Since we have our database on drives that are RAID 1,0 (mirrored + striped), do we still get benefit from putting large and busy tables on their own storage area?
"Steve Snyder" wrote:
>>We are migrating to V9 from V8.3c.
>The benefit of storage areas seems to be that certain>high I/O tables can be seperated from other parts of
>the database. >Since we have our database on drives that are RAID 1,0
>(mirrored + striped), do we still get benefit from putting
>large and busy tables on their own storage area?
Yes. You should get advantages of storage area
but you need to design storage area extents
spread across the disk and your benefits
depends upon again how much is the size of
your table and table I/O.
Try to implement on test box with and without
separate storage area and benchmark before
implementation .
Sunil