Re: Batch and OLTP at the same time : Mission possible ?

Bertrand,

Okay, to put it into simple terms:
   - You currently do the batch task during off-hours and now you are being
asked to move the task to the times when the database is busy?
   - Most of the batch activity is inserts, with just a few updates?

If your site is equipped to do perfomance testing of the database, that
would be ideal. Simulate the interactive load, then start the batch process.
But if you are like most of us, that doesn't exist.

My advice would be to "start slow". Get baseline performance readings with
just the interactive load. STATSPACK does a good job for that sort of thing.
Also, (per Cary Millsap) try to measure current interactive user response
from the user's terminal as accurately as possible. If the batch job is
running off-hours now, get baseline performance readings while it is running
also. You may be able to get a rough idea of the combined database load

Other related posts: