commentBlock = $("#comment_post_23438").find('.comment-blocks'); commentBlock.find('.loading').hide(); commentBlock.find('.see-all-comments').hide(); commentBlock.html("
I found Microsoft BI stack to be far better and it\'s \"free\" since it comes along with sql server. Since it is free people usually do not care much about its advantages but more loud about its disadvantages. SSRS is one of my favorite tools, it provide flexibility and good web support and strong AD integration for security. SSRS should not be running in the production server instance as it will kill your performance. Second, make sure it runs in a scale out manner (more than one server) based on total load. Third, change the memory setting in your SSRS configuration so that it can utilize more memory in the server rather than default, it will cut down the rendering. Fourth, never run big reports on the production server, find an alternative solution, if that\'s not possible then use resource governor so that your production database will not get the performance hit. Check query response time and actual query plan for long running reports match up with dba\'s performance baseline for that day.<\/p><\/div>