This is a migrated thread and some comments may be shown as answers.

Database Server CPU spikes when I generate report

2 Answers 64 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Efren
Top achievements
Rank 1
Efren asked on 03 Aug 2015, 07:43 AM

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

Sort by
0
Efren
Top achievements
Rank 1
answered on 05 Aug 2015, 08:02 AM

Hi,

 

Anyone here?

0
Stef
Telerik team
answered on 05 Aug 2015, 12:37 PM
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
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
Tags
General Discussions
Asked by
Efren
Top achievements
Rank 1
Answers by
Efren
Top achievements
Rank 1
Stef
Telerik team
Share this question
or