> We find
> that if one usr is running a fairly big report the CPU Useage on the Server
> goes to 100% and all other users have a serious spped degredation when
> trying to access data at the same time.
The first thing I would is look at 'fixing' the report SQL so it does not use
100% CPU, as 100% CPU use is normally sign of a badly writen SQl statement
that does not use the correct index etc.
Can you post the PLAN for the sql statement that is causing the 100% CPU
usage?
Cheers
Phil
--
Linux 2.4.4-4GB
11:53am up 31 days, 11:36, 1 user, load average: 0.23, 0.05, 0.02