slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: SSRS 2005 Performance Issue - Rendering Matrix Report

Veronka Capone
Posts: 113

SSRS 2005 Performance Issue - Rendering Matrix Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Mar 09 1:39 PM

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.

Report Design
- back-end: SQL 2005, SP 2
- I am using a stored procedure to get the data from the DB (it takes less than 1 sec to run it on SSMS)
- Problem: looking at the performance on the SSRS Server I see CPU spiking up to about 60% (w3wp process) when I execute this report.

Report Server stats:
- different server than DB server
- SSRS 2005
- 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.

[Reply][Quote]

Veronka Capone
Posts: 113

Re: SSRS 2005 Performance Issue - Rendering Matrix Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Mar 09 2:11 PM

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.

So what I do now?

[Reply][Quote]

Phil Parkin
Posts: 819

Re: SSRS 2005 Performance Issue - Rendering Matrix Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Mar 09 12:01 AM

Try using a different browser to validate your suspicions? For example I know that, for SLX Web, Chrome is much faster.

[Reply][Quote]

Veronka Capone
Posts: 113

Re: SSRS 2005 Performance Issue - Rendering Matrix Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Mar 09 7:40 AM

I tried Crome it's very fast but formating is awful. And most of the users use IE7

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/28/2024 9:17:09 PM