Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2012-03-28 : 15:46:22
|
| Anybody encounter weird performance issues after moving from sql 2005 to sql 2008 R2 SSRS?Seriously.Most of our reports are running slow. Please chip in...The CPU on any computer where we run the report pegs to 100%. Even on a Server where we have 4 CPUs the same exact thing.I posted this in the SSRS and AS forum, nothing at all.I am at a point of total exasperation.Thanks.RegardsParesh MotiwalaBoston, USA |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-28 : 15:49:07
|
| you mean all other things are unchanged? Indexes,statistics etc?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2012-03-29 : 07:08:18
|
| folks. Thanks for the responses. Yes, I do reindex the source and the ReportServer databases everyday.The perfmon shows max cpu usage by IE. When I run the same report in Report Builder, it returns the results in 2 seconds.As to wait stats, it hardly has any thing on the activity monitor, that is greater than a 1 sec blip.RegardsParesh MotiwalaBoston, USA |
|
|
|
|
|
|
|
|
Performance Issues with SQL 2008 R2 Reporting Svc