Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
AGS Server Studio - Extent Calculator
33 views
Skip to first unread message
Sean Baker
May 14, 2013, 5:08:16 PM5/14/13
to inform...@iiug.org
IDS 11.50.FC6 running on Linux RHEL 5.3
We're in the process of moving our production databases (about 200GB) to new disk space, so I wanted to take the opportunity to recalculate the extent sizes for some of our larger tables.
I'm planning on using the Extent Calculator in AGS Server Studio (version R.9) to determine the new extents. It takes row count, monthly growth %, index fill % and est. fill % for varchar columns into consideration to determine optimal extent sizes to accommodate 6 months of growth in the "next" size.
Does anyone have any experience using this calculator? Were you happy with the results?
Thanks,
Sean.
We're in the process of moving our production databases (about 200GB) to new disk space, so I wanted to take the opportunity to recalculate the extent sizes for some of our larger tables.
I'm planning on using the Extent Calculator in AGS Server Studio (version R.9) to determine the new extents. It takes row count, monthly growth %, index fill % and est. fill % for varchar columns into consideration to determine optimal extent sizes to accommodate 6 months of growth in the "next" size.
Does anyone have any experience using this calculator? Were you happy with the results?
Thanks,
Sean.
0 new messages