Hi,
I have a table which gets around 20 Mln records (transactions) per day. I need around 10 Mln of them (based on the transaction name) or 50%.
The destination for these records would be Websphere mq. The records need to go there as close to real time as possible, as they will be used for fraud detection.
Would service broker be a good solution for this? Would it handle 10Mln records per day with the average record size of about 1.1 KB? The 10 Mln records are not evenly spread, from 9am to 5pm (being peek) we get around 50% of them.
Thanks.