Hi Harish - avoiding strain on the Prod DB is definitely a priority, so you are right to be thinking about a secondary DB. The BP DB is for operational purposes and should not be thought of as a data repository - hammering it with MI queries will affect Production.
Aside from thinking about what data is required, I guess you'd also need to consider the refresh rate - for some data there would be no point in attempting high frequency updates. And even for things like session or queue status, the business requirements might not require real-time updates.
------------------------------
John Carter
Professional Services
Blue Prism
------------------------------