[cspadola]

The way we use OTM here requires us to create many bulk plans each day (approx 300 average) which consist of anywhere from 1 to 25 orders selected for each. Also, though we do bulk planning throughout the day, we do have a busy period between 15:00 and 19:00 at which time our Planning teams submit multiple bulk plans simultaneously. During this busy period, the perception of each user for their bulk plan, regardless of number of orders selected, is that OTM is too slow. In reality, we are averaging about 4-5 seconds per order per bulk plan which is, in my opinion, quite good. The real bottleneck here is that the recommended thread setting for bulk plans in OTM is 2 with a max of 4 recommended. We tested with 4 and decided it was safer to stay with the default 2 threads. Actual waiting times (on the user side) can be as long as 30 mins while the actual processing time for the bulk plan is perhaps 1-2 mins.

And now my question...is there a way to see how many bulk plans are queued up waiting for one of the two threads to become available? The Event Diagnostic tool shows me what each thread is doing but it does not tell me how many new bulk plans are waiting to be processed. I can look direct to the DB for bulk plans for today but this only tells me details of bulk plans already run.

Is there another tool I can use that will show me the queue?

Thanks