I was asked to take a look at an older Sybase ASE 12.5 database which was performing slowly.
I installed a trial of DBArtisan locally on the DB Server host (a VM). Then I ran the space analyst and clicked on the two major DBs and show object frag scores...
Database 93%
Tables 99%
Indexes 85%
Am I reading this properly? The DB is fragged beyond reason?
So now the test.. how do I fix?
I also noticed that the datafile structure is odd .. 20GB files and a lot of them all on the same drive letter (yes this is on windows 2003 and we have misaligned partitions..also)
My question is on the best approach...
How can I use DBArtisan to create NEW larger datafiles... and rebuild the tables and indexes in them non fragged? HOW? or is there a better way?
Suggestions?
Thanks in advance..