Unanswered: [ASE12.5Win2k] Slow select/recovery-performance
My ASE 220.127.116.11 Win2000-machine is very, very slow when it comes to recovernig a large database (8Gb data, 5+Gb log). It takes almost half an hour to redo 5% of the records. Selectstatements take up as much as 50% CPU, 2 statements even push it up to 100%, making the machine terribly slow.
A similar machine, with less hardwarecapacity performs much better, while it is similar configured, only usable memory is less (due to lack of RAMexpansionslots..).
Can anyone point me in the right direction? Thanks!
I'm not crazy, I'm an aeroplane!