ramana3327 (10/23/2014)
Yes but now it is hitting the production database performance (OLTP). That is the reason they want the read only copy for the reporting source
It would be far easier and cost effective to analyze the query(ies) that support the report and fix them so they run more quickly and with fewer resources. 3 orders of maginitude performance increases and resource usage decreases are more common than you think if you just spend some time working the code and maybe some indexes.
Like Gail suggested, moving the data to a read only copy of the data is going to buy you very, very little especially when compared to how much the cost will be to do so.
--Jeff Moden
Change is inevitable... Change for the better is not.