Post reply

SSRS Performance issue

  • 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

  • March 27, 2012 at 10:21 am

    #1465115

    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?

  • March 27, 2012 at 10:58 am

    #1465163

    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

  • March 27, 2012 at 11:17 am

    #1465186

    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.

  • March 27, 2012 at 11:21 am

    #1465190

    Are you running IE8 in compatibility mode?

    MWise

  • March 27, 2012 at 11:27 am

    #1465198

    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

  • March 27, 2012 at 11:41 am

    #1465219

    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

  • March 27, 2012 at 11:49 am

    #1465230

    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.

  • March 27, 2012 at 2:14 pm

    #1465330

    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

  • March 28, 2012 at 2:03 am

    #1465510

    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...

  • March 28, 2012 at 8:47 am

    #1465730

    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

  • March 28, 2012 at 8:50 am

    #1465731

    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

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

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