That is what I suggested. Offload the select queries and just use production for insert, update, delete queries. Then just replicate to multiple subscribers based on the amount of reporting...