May 12, 2015 at 9:27 am
We have installed recently SSRS 2014 (SQL 2014 RTM) and deployed the reports into the server and all users being accessed. We have done memory configuration in config file and Hardware also High configuration (RAM 512 GB), But we are getting below performance issues
1) When restart the SSRS server/recycle, for the first time report generation is taking time 12 sec.
from 2nd time report is getting generated in 4 or 5 sec (it is ok but our users proffered report generated in 1 or 2 sec)
Why the first time report taking some time after restart the service ? can we get the report in 1 or 2 sec ?
2) When we are trying to generate the SSRS report from .net Application its taking 12 sec and at first for few seconds blank pages is appearing after that data is loading into report. (from SSRS URL its taking only 5 sec)
Why the blank page is appearing when report accessing from .Net App ?
any suggestions for these two issues would be Appreciated.
May 12, 2015 at 9:32 am
sreenubabu.s (5/12/2015)
We have installed recently SSRS 2014 (SQL 2014 RTM) and deployed the reports into the server and all users being accessed. We have done memory configuration in config file and Hardware also High configuration (RAM 512 GB), But we are getting below performance issues1) When restart the SSRS server/recycle, for the first time report generation is taking time 12 sec.
from 2nd time report is getting generated in 4 or 5 sec (it is ok but our users proffered report generated in 1 or 2 sec)
Why the first time report taking some time after restart the service ? can we get the report in 1 or 2 sec ?
2) When we are trying to generate the SSRS report from .net Application its taking 12 sec and at first for few seconds blank pages is appearing after that data is loading into report. (from SSRS URL its taking only 5 sec)
Why the blank page is appearing when report accessing from .Net App ?
any suggestions for these two issues would be Appreciated.
Have you migrated databases from an earlier version of SQL Server?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
May 12, 2015 at 10:17 am
no it is new installation only.
May 13, 2015 at 2:45 am
Databases also newly created.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply