Re: Batch job slows down
Posted in 2010
Some new information: - we turned off the btscanner, no difference. It is not a problem in the btscanner - reorg of the table where all transactions are loaded and then deleted from lowered the time per transaction from 0.3 seconds to 0.15 seconds. (The average time before the problems started was 0.03 seconds). Inspired by this a reorg of a number of tables was done, this has not further reduced the transaction time. - EMC has checked and found that we do have a problem with the load of the SAN. We will now schedule the batch in such a way that we know that there is no other activities and see if the SAN can account for the rest of the problem - if this does not explain the problem we will look for other solutions in a test environment