| Author |
Topic |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2012-02-23 : 11:04:13
|
| Hello all.Please howl, if you have come across this issue.We have a perfectly fine working report on a SQL 2005 SSRS box.Its Data is coming from a SQL 2005 Database server and the SSRS REporting database lives on another server which is also a SQL 2005 box.Recebntly we picked that report and moved it to a SQL 2008 R2 SSRS Box, the Data still comes from SQL 2005 box and the Reporting databse live on a SQL 2008 R2 box. This report runs tremendously slowly. The queries of the underlying reports run fine. It is jsut taking a lot of time in rendering.Some suggestion as to applying sp1 for sql 2008 R2. Other than that if you have come across any particular issue(and solutions), please share them with me.RegardsParesh MotiwalaBoston, USA |
|
|
SMK
Starting Member
6 Posts |
Posted - 2012-02-24 : 00:33:50
|
| In your report say for example 10000 rows are there to be dispalyed. whether all the 10000 rows are dispalyed in the same page or page break is applied?SMK :) |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2012-02-24 : 08:55:55
|
| Hi SMK, it has no page breaks, albeit a lot of columns. there is not much data...just a lot of rendering.RegardsParesh MotiwalaBoston, USA |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2012-02-27 : 14:44:29
|
| some more experiments : the internet explorer goes 50% on the machine where we run it. So if we run it directly on the server it still runs 50%. and it almost exactly runs for 150 seconds.We even moved the VM to another host....same exact results. The memory pressure is almost zero, the CPU utilization by SSRS is almost nothing. Unless somebody has better options, redesigning the report may be the only way to go.Anybody have ideas?RegardsParesh MotiwalaBoston, USA |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2012-02-28 : 09:32:17
|
| some more weird testing leads me to believe it is an IE issue.When I run this report in BIDS or Report Builder, it takes 5-10 secondsin Google Chrome 30-40 secondsIn IE 9 it takes 90 seconds.come on folks, we have some serious champions here.Somebody must have seen something as bizzare as this...!! for sure.RegardsParesh MotiwalaBoston, USA |
|
|
|
Danny_SQL_9876
Starting Member
8 Posts |
Posted - 2012-03-03 : 14:05:46
|
| Hey Paresh,I had exactly the same problem with one of the SSRS 2005 Report. after 2 days of research and testing i found out that the problem was with 'List' in the report.I had a table which displays around 80000 records, and this table was inside a List which would group the records by a parameter selected by users. report would take 25 minutes to run where as the sql behind it returns results in 2 sec.I took the table out of the LIST and replaced the logic with table group and the report was returning results in 5-10 sec.you might also wanna try to remove any Document Maps, Images, text Boxes with calculations on string and test the report. also Check if it is PARAMETER SNIFFING (http://www.bidn.com/blogs/BradSchacht/ssis/1185/working-around-parameter-sniffing)is causing the issue.also when you fix this issue, please let us know what the issue was and how you fixed it! good luck |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2012-03-11 : 01:09:35
|
| we have many reports where we don't have Lists. The rendering of the reports is just slow on sql2008 and virtually any browser combination, The fastest combination seems to be with Chrome. where instead of 2:30 seconds it takes 35 seconds. I further unchecked the Third Party Extensions in the browser and it now definitely completes in 2mins 10 seconds. when the reports run, the CPU shoots upto 25% on the machine where browser is, no matter how many CPUs we have.RegardsParesh MotiwalaBoston, USA |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2012-04-25 : 09:39:27
|
| Ok folks, something that almost doesn't happen here. I am gonna post the findings. IT is not good.We recruited MS premier support. AFter 2 months, finally they said, slowness is a known issue in 2008 SSRS. and refunded our premier hours.They basically said to change all of our 2000 reports... and later they agreed they have a problem....RegardsParesh MotiwalaBoston, USA |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-25 : 10:02:18
|
| SSRS is not in Sharepoint Integrated mode is it? If it is then change it to native mode... I will not even begin to tell you how many gray hairs are on my head because of this.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2012-04-25 : 10:19:41
|
| Thanks Lumbago, but no, it is a purely dedicated SSRS server. Not even database services. They just mentioned that the way the reports are rendered are now at client side and not server side. IE8 or 9's slowness is exposed. the same report runs in half the time with Chrome. But it is not our supported browser.RegardsParesh MotiwalaBoston, USA |
|
|
|
|
Speed Issues with SQL 2008 R2 SSRS