Report Performance issues - time in processing -- sql server reporting services

AMasson
5/26/2006 3:12:00 AM

I'm having performance issues with a report which is taking nearly 22
minutes to return 2100 rows. I've queried the execution log tables and
the Time in Processing accounts for more than 99% of this.

The report is applying cell formatting using a coded function to
retrieve formatting from a stylesheet which hasn't proved problematic
so far with other reports, and has several levels of grouping in a
single table with sub-totals for each group level and an overall table
total. There's also conditional criteria for the grouping expressions
depending on report parameters passed in.

Anyone have any ideas as to the most likely cause for the poor
performance? Are there any guidelines as to what causes most overhead
for report processing; what to avoid, impact of multiple levels of
groups etc

Any help appreciated.

DimSum
5/26/2006 3:39:02 AM

Instances where i found the report is running slow like you described are:
1. Open join in the sql query,
or more likely ..
2. a dataset created but not used in the report

I would run the sql in a database to see if the problem is in the sql of
formatting.

Hope this helps.

[quoted text, click to view]

Bruce L-C [MVP]
5/26/2006 8:16:27 AM

One other thing to look for is grouping in the RDL not used. Open up the RDL
directly and look for grouping. I had this happen once in RS 2000. The ide
did not show the grouping but it was still there and it caused problems.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Report Performance issues - time in processing