Hi Telerik,
We've been experiencing performance issues on our reports...
Whenever I run a report, just 1 report... The database server CPU spikes up...
from 1% consumption it spikes up to 99%... drastic...
Please see attached file for DB server specs and other screenshots
Thank you so much.
2 Answers, 1 is accepted
0
Efren
Top achievements
Rank 1
Rank 1
answered on 05 Aug 2015, 08:02 AM
Hi,
Anyone here?
0
Hello Efren,
In the case of IIS processes each process has a limitation of the used for it data - memory for the IIS process. During the report generation beside the retrieved data, there are newly generated resources by the report, which are held in memory. Thus the machine should have enough memory and CPU to handle the amount of data and the document processing.
Our concerns about rendering large amount of pages are already known. My colleague has explained them here. (Performance Considerations) - link to our performance considerations article, where you can find suggestions how to optimize the report e.g., filter data on retrieval, enable the reports resources caching and etc.
You can test the HTML5 Report Viewer and deploy the application in a web farm by configuring the Reporting REST service IStorage. Thus requests for reports can be balanced between multiple machines.
I hope the provided information is helpful.
Regards,
Stef
Telerik
In the case of IIS processes each process has a limitation of the used for it data - memory for the IIS process. During the report generation beside the retrieved data, there are newly generated resources by the report, which are held in memory. Thus the machine should have enough memory and CPU to handle the amount of data and the document processing.
Our concerns about rendering large amount of pages are already known. My colleague has explained them here. (Performance Considerations) - link to our performance considerations article, where you can find suggestions how to optimize the report e.g., filter data on retrieval, enable the reports resources caching and etc.
You can test the HTML5 Report Viewer and deploy the application in a web farm by configuring the Reporting REST service IStorage. Thus requests for reports can be balanced between multiple machines.
I hope the provided information is helpful.
Regards,
Stef
Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items