Database Server CPU spikes when I generate report

3 posts, 0 answers
  1. Efren
    Efren avatar
    8 posts
    Member since:
    Jun 2014

    Posted 03 Aug 2015 Link to this post

    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. Efren
    Efren avatar
    8 posts
    Member since:
    Jun 2014

    Posted 05 Aug 2015 Link to this post

    Hi,

     

    Anyone here?

  3. DevCraft banner
  4. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 05 Aug 2015 Link to this post

    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
Back to Top