9/13/2025 11:28:50 PM
|
| |
| 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!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
SSRS 2005 Performance Issue - Rendering Matrix Report
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.
|
|
|
|
Re: SSRS 2005 Performance Issue - Rendering Matrix Report
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?
|
|
|
| |
| |
|
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!
|
|
|
|
|
|
|
|