outside SSRS report possible issues question

donit

Hi,

We're mainly using data-warehouse to run outside SSRS reports on NAV data. However, for a few reports users need real-time data so I'm going to link those few SSRS reports directly to the production data. I'm considering running stored procedures on the production server or on the different server getting data from the production in real-time (linked server).

Please, advise if I could expect any impact on the NAV performance or/and issues with locking tables, preventing transactions posting, etc., and how I could reduce the impact if it's possible.

Thanks