Dynamics Community Forum Thread Details

Usage profiler - how to fill out

Hi,

We have a customer with a go live coming up, with very high transactions volumes. How do we fill the usage profiler for each of the transactions types?

For instance, we have about 2000 order with about 250k order lines per day. These come in through EDI and in 3 batches. This means that in one hour we need to process aboug 600 orders, with 80000 lines. Obviously every orderline has multipe additional records that need to be created / updated. Perhaps 10 (or perhaps even more) fold that number. That would make a total number of transactions of more than 800.000 for the sales orders. Then we invoice all lines in batch every night. With the ISV transactions, this is probly an even higher peak. Invoicing currently only takes about 1 hour. Keeping to this, we can enter the number of invoices. Problably only something like 500, but that are 250000 invoice lines and with all other records that are update and or created most likely > 10.000.000 records

Does anybody have any hints on how to poplulate this usageprofile spreadsheet

Thanx

Herre

Quick Links