SSRS Performance issue

Question

SSRS Performance issue

WayneS

SSC Guru

Points: 95460
More actions
March 27, 2012 at 10:08 am

#253191

Environment: SQL 2008R2 x64, SP1
Various browsers / users are having different performance issues just working around SSRS. ie. opening up the web page, drilling into a folder, and finally launching the report to where it prompts for the parameters (not actually running the report):
User 1: IE / chrome very slow, wireless.
User 2: IE very slow, FF fast, wired.
User 3: IE very slow, FF fast, wireless.
User 4: IE works fine, wireless.
When I say IE is slow, it seems unresponsive. Progress bar crawls, but never completes. It's like cold molasses trying to flow uphill.
I see where SP1 includes CU 1-6; and CU7 addresses some SSRS performance issues. However, what CU7 is talking about is within the report itself; what we're seeing is before we even get to the report, so it doesn't seem like this would apply.
I greatly appreciated any and all help in trying to figure this out.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Viewing 12 posts - 1 through 11 (of 11 total)

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

HowardW One Orange Chip Points: 29109 More actions · Answer 1

Is it slow when using both the Report Manager and Report Server interfaces?

Chrome has a known bug that can consume all the client CPU in a loop, but IE and Firefox are generally fine. What version of IE?

Do you connect via a proxy?

WayneS SSC Guru Points: 95460 More actions · Answer 2

HowardW (3/27/2012)
Is it slow when using both the Report Manager and Report Server interfaces?
Chrome has a known bug that can consume all the client CPU in a loop, but IE and Firefox are generally fine. What version of IE?
Do you connect via a proxy?

IE8

I'm using the http://<servername>/Reports_<InstanceName>/Pages.Folder.aspx link, which should be the Report Server interface.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 3

WayneS (3/27/2012)
HowardW (3/27/2012)
Is it slow when using both the Report Manager and Report Server interfaces?
Chrome has a known bug that can consume all the client CPU in a loop, but IE and Firefox are generally fine. What version of IE?
Do you connect via a proxy?
IE8
I'm using the http://<servername>/Reports_<InstanceName>/Pages.Folder.aspx link, which should be the Report Server interface.

Try it without the /pages.folder.aspx

Seems to me last week testing an iPad, http://server/reports on my default install was different than with this on the end.

MWise SSCarpal Tunnel Points: 4074 More actions · Answer 4

MWise

SSCarpal Tunnel

Points: 4074

March 27, 2012 at 11:21 am

#1465190

Are you running IE8 in compatibility mode?

MWise

WayneS SSC Guru Points: 95460 More actions · Answer 5

Greg Edwards-268690 (3/27/2012)
WayneS (3/27/2012)
HowardW (3/27/2012)
Is it slow when using both the Report Manager and Report Server interfaces?
Chrome has a known bug that can consume all the client CPU in a loop, but IE and Firefox are generally fine. What version of IE?
Do you connect via a proxy?
IE8
I'm using the http://<servername>/Reports_<InstanceName>/Pages.Folder.aspx link, which should be the Report Server interface.
Try it without the /pages.folder.aspx
Seems to me last week testing an iPad, http://server/reports on my default install was different than with this on the end.

Without the "Pages/Folder.aspx", it redirects to with it.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

HowardW One Orange Chip Points: 29109 More actions · Answer 6

Using http://<servername>/Reports%5Bb%5Derver%5B/b%5D_<InstanceName>/ should go to the Report Server interface. It's much lighter weight if you don't need users to manage report subscriptions/settings

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 7

I was seeing was a hang with it, but fine without and being redirected as you noted.

Safari 5 was being used, over wireless internal network.

When not needed, I try to avoid hitting a hard coded page address.

I see you have no Safari included in your mix.

Is it possible to see if on the fast IE, installing another browser slows things down?

Or removing FF on one speeds things up?

Just an idea.

WayneS SSC Guru Points: 95460 More actions · Answer 8

HowardW (3/27/2012)
Using http://<servername>/Reports%5Bb%5Derver%5B/b%5D_<InstanceName>/ should go to the Report Server interface. It's much lighter weight if you don't need users to manage report subscriptions/settings

This goes to a listing of directories / files. Kinda like jumping out to a cmd prompt and typing dir. Is this normal?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

HowardW One Orange Chip Points: 29109 More actions · Answer 9

WayneS (3/27/2012)
HowardW (3/27/2012)
Using http://<servername>/Reports%5Bb%5Derver%5B/b%5D_<InstanceName>/ should go to the Report Server interface. It's much lighter weight if you don't need users to manage report subscriptions/settings
This goes to a listing of directories / files. Kinda like jumping out to a cmd prompt and typing dir. Is this normal?

Yes, it's normal. Just interested to see if it's fast accessing reports over that interface rather than the full report manager one...

WayneS SSC Guru Points: 95460 More actions · Answer 10

Mhlewis (3/27/2012)
Are you running IE8 in compatibility mode?
MWise

Only "Display Intranet sites in Compatibility view" is selected.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95460 More actions · Answer 11

HowardW (3/28/2012)
WayneS (3/27/2012)
HowardW (3/27/2012)
Using http://<servername>/Reports%5Bb%5Derver%5B/b%5D_<InstanceName>/ should go to the Report Server interface. It's much lighter weight if you don't need users to manage report subscriptions/settings
This goes to a listing of directories / files. Kinda like jumping out to a cmd prompt and typing dir. Is this normal?
Yes, it's normal. Just interested to see if it's fast accessing reports over that interface rather than the full report manager one...

No, that's pretty slow also.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2