azsat
asked on
Sybase Space issues
Hi,
I've got a question regarding data segments on databases which end up full eg 99% full and we need the data ie can't really delete old tables etc what can we do?
They end up full because the data is growing and a minimum amount of historical data is needed. Thecdata is BCP'd in daily and there is not really much saying what the volumes will be and hence the fact that the data segment gets fully on a regular basis.
What can we do?
1. Ask for more space how can we work how much more space to ask for?
2. Look out for fragmentation? what can we do?
3. Drop and recreate indexes that appear to gooble up more space then the table data itself?
5. Anything else?
Thanks!
I've got a question regarding data segments on databases which end up full eg 99% full and we need the data ie can't really delete old tables etc what can we do?
They end up full because the data is growing and a minimum amount of historical data is needed. Thecdata is BCP'd in daily and there is not really much saying what the volumes will be and hence the fact that the data segment gets fully on a regular basis.
What can we do?
1. Ask for more space how can we work how much more space to ask for?
2. Look out for fragmentation? what can we do?
3. Drop and recreate indexes that appear to gooble up more space then the table data itself?
5. Anything else?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome, hope it wasn't too much detail! 8->
ASKER