none
SSRS report taking more time but fast in SSMS

    Question

  • SSRS report taking more time but fast in SSMS,We are binding a string which more than 43000 length each and total number records is 4000.

    Plese do the needful.It is not possible to create index because it crosses 900 byte.

    Sunday, December 29, 2013 5:27 PM

Answers

  • Hi DBA5,

    As per my understanding, when previewing the report, there are three options to affect the report performance. They are data retrieval time, processing time, rendering time.

    The data retrieval takes time to retrieve the data from the server using a queries or stored procedures, the processing time takes time to process the data within the report using the operations in the layout of the report and the rendering time takes time to display the information of the report and how it is displayed like excel, pdf, html formats. It is the reason why report take more time than in SSMS.

    To improve the performance, we need to improve the three aspects. For the details, please see the great blog:http://blogs.msdn.com/b/mariae/archive/2009/04/16/quick-tips-for-monitoring-and-improving-performance-in-reporting-services.aspx

    Hope this helps.

    Regards,
    Heidi Duan


    Heidi Duan
    TechNet Community Support

    Monday, December 30, 2013 9:59 AM
    Moderator