How can I generate reports form Azure SQL that does not slow the system down?

Vote count:

0

I hope someone can give me advice or point me to some readings for this. I generate business reports for my team. We host a subscription website so we need to track several things sometimes on a daily basis. A lot of sql queries are involved.The problem is querying a large volume information from the live database will slow or cause timeouts to our website.

My current solution requires me to run bcp scripts that copy new rows to a backup database, (that I use purely for reports) daily. Then I use an application I made to generate reports from there. The output is ultimately an excel file or several (for the benefit of the business teams, it's easier for them to read.) There several problems in my temporary solution though,

1. It only adds new rows. Updates to previous rows are not copied. and


2. It doesn't seem very efficient.

Is there another way to do this? My main concern is that the generation or the querying should not slow down our site.

asked 53 secs ago

deadsacred

1