Post reply

Rendering matrix report - performance issue

  • March 18, 2009 at 12:25 pm

    #201113

    Hello everyone,

    I have a matrix report (137 cols\ 596 rows -- which will grow in the future), rendering very slowly. It takes about 20 seconds for the report to show up in the browser.

    - SSRS 2005,

    - back-end: SQL 2005

    - I am using a stored procedure to get the data from the DB (it takes less than 1 sec to run it on SSMS)

    - looking at the performance on the SSRS Server I see CPU spiking up to about 60% when I execute this report.

    Server stats:

    - virtual 2003 Win server, Service Pack 2

    - dual processor

    - 3 GB of RAM

    Any suggestions what I can change to speed up this report? Some settings maybe?

    Thanks.

  • March 18, 2009 at 1:13 pm

    #962204

    Looking at Execution log on ReportingServer, I see tha Total Execution Time (TimeDataRetrieval + TimeProcessing + TimeRendering) it is not more than 2 seconds. That means painting it in the browser takes up majority of the time.

    I am using IE7.

    How do I fix it?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply