Link to home
Start Free TrialLog in
Avatar of azsat
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!
ASKER CERTIFIED SOLUTION
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of azsat
azsat

ASKER

Thanks!
You're welcome, hope it wasn't too much detail! 8->