You must Sign In to post a response.
  • Category: SQL Server

    Why SSRS Report server loading very slowly

    Hi
    any one please let me know the below problem.

    1. why SSRS report is loading very slow from user PC in same domain but inside server is faster.
    i have configured SSRS report in server and if i running report server URL inside the server where my report is deployed is faster(3s) but when user is accessing same URL from their PC in same domain it's very very slow(5 mins). if after click on view button , if it's taking time then i may guess that may be data is huge but my case if no data also for initialize reporting viewer taking long time. i have checked store procedure result , it's very faster.

    2. in chrome browser report viewer is not loading properly it's not loading properly in chrome browser. any chrome setting required?
    Thanks
  • #766544
    Hi,

    For any issue which related to performance first we need to optimize the query to fetch data very fast, but in your case data fetched very fast but still you face the problem means I guess the problem might be rendering the report builder, refer below link may be this might helpful to you

    http://www.sqlchick.com/entries/2011/1/25/whats-up-with-the-slow-ssrs-r2-rendering-in-sharepoint-2010.html

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #766556
    Hi,
    For 1. Please check your query in SQL profiler to check what part of it takes more time.
    For 2. Try setting attributes of ReportViewer as follows:
    SizeToReportContent="True" and Height="100%"

  • #766558
    Hi,
    I have also faced the same problem that SSRS report not loading properly in Chrome browser, but works fine in explorer and firefox.
    To get the SSRS report, we need to modify some chrome setting,
    Step 1: Right click on chrome , goto inspect element.
    Step 2: Find the div whic has ID "VisibleReportContent"(ctrl+F and type 'VisibleReportContent'), find the id of that parent div (parent id start with 'ctl%')
    Step 3: Notedown the parent ID.
    Step 4: Goto "C:\Program Files\Microsoft SQL Server\MSRS11.SQLEXPRESS816\Reporting Services\ReportManager\js"
    Step 5: Paste the below code, at the end of the .js file.
    <pre>function pageLoad() {
    var element = document.getElementById("ctl99_ctl99");
    if (element) {
    element.style.overflow = "visible";
    }
    }</pre><b>Note: </b> replace the ctl99 with your Id
    Step 6 : Save it, now you can able to view SSRS report in chrome browser.

    Hope it helps

  • #766757
    Hi Everyone,
    Already searched this from internet and tried still it's slow, even for me in IE also it's taking time just to load empty report viewer.

    inside server is fine problem from another user PC which i guess no problem for any browser setting

    query or SP if having problem then i may need to do optimize but for my case SQL query don't have any problem at all.

    let me know if have any other idea.

    Thanks

  • #766779
    How you are browse your site with servername or IP address, many times IP address name, does not resolve and hence it gets slow.
    try to browse website with server name or vice varsa

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]


Sign In to post your comments