SSRS Slowness

Question

SSRS Slowness

durai nagarajan

SSCoach

Points: 15775
More actions
May 26, 2014 at 8:30 am

#289161

Hello Experts,
I have situation where in SSRS is slow.
I google regarding that and got a query to find the issue
Select * From Executionlog2
Mostly my rendering is taking more time but there is solution found for this.
More over the export to excel is taking more than 20 minutes due to that time out happens and user not able to retrieve the data. The report has around 9500 rows data.
smaller reports are working fine. i need solution for this.
one more doubt can SSRS be configured on cluster server?
Regards
Durai Nagarajan

Viewing 5 posts - 1 through 4 (of 4 total)

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

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 1

A normal type-written piece of 8-1/2" x 11" piece of paper (portrait orientation) will normally contain 60 lines (at 12pt font) or almost 80 lines (10 pt font). At 80 lines per page, that means that your 9,500 line report will be at least 118 pages long.

I have to ask... who's going to read all that?

If it's absolutely necessary that this info be made available in Excel, I'd pick a different method than using SSRS. For example, you could create the Excel spreadsheet to pull the data from SQL server or you could export the data to a TSV file and import it using Excel. Both would be lightning quick compared to SSRS and both would save on a whole lot of network traffic/resource usage because the HTML that SSRS creates is just nasty thick with unnecessarily repetative HTML tags.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

durai nagarajan SSCoach Points: 15775 More actions · Answer 2

Thanks jeff

this is a some Human resources report which we cant modify. i'll try to implement your suggestion but not immediately.

4 or 5 days back it was working fine suddenly the rendering and export started behave wierdly.

Regards
Durai Nagarajan

durai nagarajan SSCoach Points: 15775 More actions · Answer 3

any one have idea on this

one more doubt can SSRS be configured on cluster server?

Regards
Durai Nagarajan

MMartin1 One Orange Chip Points: 27764 More actions · Answer 4

Are your reports calling stored procedures or using embedded SQL? Are there lots of joins in the code? Is all the data on the same machine?

If the sole purpose of this report is to do aggregates in Excel, then also consider what Jeff mentioned about pulling the data directly into Excel from Sql Server.

----------------------------------------------------