Need to generate Report from a Production Database

Posted by Saranpselvam under Sql Server on 4/23/2014 | Points: 10 | Views : 458 | Status : [Member] | Replies : 1
Hi ,

We have a production database which is busy throughout the day and need to generate report from the same. The tables undergoing inserts/updates will be used to select the data for the reports. Due to this I am facing low performance.
Thank you


Posted by: Vuyiswamb on: 5/23/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

What makes it slow ? a select wont make it slow unless you are not selecting wisely. show us an example of your report Query and when you mean "busy" can you elaborate more clearer.

Thank you for posting at Dotnetfunda

Saranpselvam, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response