Archives of the TeradataForum

Message Posted: Wed, 22 Mar 2006 @ 13:18:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

We also automate the space management on databases but only in the Development/Test environments. Our developers seldom provide a good estimate of rows to be loaded or overall space they might need, resulting in over-allocated databases that we had to periodically survey and reclaim space from. Now we simply allocate a lot whenever there's a request and a weekly process keeps removing 50% of the excess until the remaining excess reaches some % of allocated, say 10%. It's eliminated our periodic review and reclamation activity and of course we know where we moved the space to so we always know where the "excess" is in the system to give out again. Works well for our development/test systems but we don't have much of an issue in production so we've never implemented it there.

Harold D. Kleven
SUPERVALU - Data Administration

	<Prev	Next>		<<First	<Prev	Next>	Last>>