M
mfurgal
Guest
Tom: Excellent job providing this table. Useful information as usual. Your understanding is correct as far as I can tell. We did a similar study with our MDBA customers and informed each or them whether they were at risk or not based on a similar algorithm. As you would suspect having a single 32 GB or 64 GB index area is pretty rare. I think we all, as a community, did a good job with storage area design back when Progress V9 came out to not have a single area called “Data” with a single associated area called “Index”. The remedy is 2 fold. 1.) Upgrade to a version of OpenEdge that has this issue fixed (preferred) 2.) If you have a large index area, split it into multiple index areas, which requires downtime to truncate the area, index-move, and index rebuild the areas. Now is the time to make sure you have no indexes in any storage area that contains table data. Mike -- Mike Furgal Director – Database and Pro2 Services PROGRESS Bravepoint 678-225-6331 (office) 617-803-2870 (cell) mfurgal@progress.com
Continue reading...
Continue reading...