Recently we have upgraded the SQL server from 2008 r2 to 2014 . Also we have upgraded the reports from SSRS 2008 to SSRS 2012. After upgradation the reports are taking a lot of time to render. Previously reports were taking 3 seconds to render and display, but the same reports in SSRS 2012 are taking 20 seconds. I have found that if remove SSRS expressions for displaying ' - ' instead of NULL it is taking 10 seconds to run and display. Instead of expressions i have used VB code but there is no change. Is there any way to solve this problem?
Asked
Active
Viewed 372 times
0
-
rebuild your indexes? – Mitch Wheat May 18 '15 at 07:10
-
http://stackoverflow.com/questions/16030633/sql-server-reporting-services-very-slow-after-migration – Mitch Wheat May 18 '15 at 07:12
-
Hi,Mitch we rebuild the indexes – anvesh.d May 18 '15 at 07:21
-
FYI....Instead of clicking the old solution file using new SSRS version, i created one solution file in SSRS 2012 and added the rdl files manually. – anvesh.d May 18 '15 at 07:36
-
make sure that index and statics are updated.use cache report that save your time. – Vishe Apr 01 '19 at 06:20