Thanks for the replies.

Yes, they are ready for the budget. They want 3 replicas for some other purpose also. One is specially for reports.

Some how now just one simple report is taking minimum 12 hr time.

The row count in that report is 28000 and byte count is 790000.

It is taking time data retrieval for that report is 32000000 ms, Time processing is 4940ms & Time of rendering 26000.

The report server is getting data from the OLTP linked server.

We need to run that report for a particular time. i.e. every 24 hrs one time.

We are not optimizing that report. So we need to have other source