locked
SSRS Report Manager browsing is slow RRS feed

  • Question

  • I have an enterprise level installation with 5 environments Dev - Production...we recently have moved from SSRS2014 to SSRS2016 to do this we created all new win2012 servers for each environment the lower level are two servers one front-end one metadata each with 16Gb memory Production is two nodes front-end one server metadata. We then did the migration with back-up restore method. This all went well we have everything functioning however one environment when going to report manager to display the root level folder approx 130 of them takes almost 10 seconds consistently. The other environments it normally can display in 2 seconds but sometimes they will also take 10 seconds to display...when it is acting up what you see if spinning circle then main header followed by more spinning then finally you see the folders. I have tried putting proc mon on the front-end and sql profiler on the metadata server to see if I can determine why I get this but have not been able to identify anything. As all of these environments were built at the same time and are equal why would I get this difference in  performance? When the report manager is acting up even running reports is very slow but when it is fast the reports are fast. Just can't put my finger on what would do this. Hope someone else has saw this and can help.
    Tuesday, August 8, 2017 4:38 PM

Answers

  • Zoe,

    Yes we finally found the issue....our new servers are Win2012 R2 VMs and for http traffic you have to disable the Receive Side Coalescing = disabled for both IP4 and IP6 on the network adapter...it is in the Advance tab of the network configuration. If you don't it will queue traffic up before processing leading to the perceived slow performance.  Our Citrix VM tech had seen it before and we were able to set this without reboot and things are working fine now.

    Here is a article about it jump down to the section on Receive Segment Coalescing (RSC)

     http://lifeofageekadmin.com/network-performance-vmxnet3-windows-server-2012-r2/

    • Marked as answer by phillip786 Sunday, August 20, 2017 1:43 AM
    Sunday, August 20, 2017 1:43 AM

All replies

  • Try to enable caching on the reports which you run so that the report data is executed before report runs. Reference:

    https://www.mssqltips.com/sqlservertip/1919/how-to-enable-caching-in-sql-server-reporting-services-ssrs/

    I hope this helps you!


    Please click the "Mark as Answer" button if this post solves your problem or "Vote As helpful if it was helpful! :)
    Explore the SharePoint

    Tuesday, August 8, 2017 5:53 PM
  • It is not running the reports it is just browsing the folders....just go to https://<server>/Reports/Browse and it takes 10 seconds to display the folders....change to a sub-folder and it takes 10 seconds to display the contents there. If you run any report while this is acting like this the report will be slow also. However when it is working correctly it displays the initial screen of folders in 2 seconds and reports run fast also. So it is something that causes the entire report manager to run slowly and therefore the reports are affected also the same.
    Tuesday, August 8, 2017 8:23 PM
  • Hi phillip786,

    Did this always happen when you navigate the Report Manager? Or It happened on the first time you open it, the next  time you opened it , it ran fast? If you change a browser, will it work well or not? 

    Based on my research, it might be related to the SQL Server Reporting Services Memory and Recycle Time. You could modify the Recycle Time in configuration file, and add more RAM. You can refer to Prevent SQL Server Reporting Services Slow Startup for details.

    In addition, when accessing the report manager after restarting Reporting Services, ASP.NET is required to start, it will spend some time to wait for that then load initial page. You could refer to Troubleshooting Report Manager Problems for details.


    If you have any question, please feel free to ask.
    Best regards,
    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, August 9, 2017 7:02 AM
  • Zoe,

    So this is a set of new servers Win2012 and fresh install of Sql 2016 16GB ram in a two server configuration. So this will happen on most environments sometimes where we go to url and it will take 10 sec. I can then go to the same url again and it continues to take 10 sec. Browse any sub-folder and takes 10 sec. This is when it acts up...now sometimes I come in and it loads in 2 sec and going to other folders it is 2 sec. If I run a report when it is browsing fast the reports are fast...if browsing is slow then reports are slow. It does this with IE, Chrome, FireFox all the same if it is slow it is slow everywhere. I feel like something is running on the front-end server that causes it to perform slowly for some period but can't put my finger on it.

    These servers we moved our reports thru back up / restore method moving up from SSRS 2014 which we never had this issue with...so the new web interface is when I saw it start.

    Thursday, August 10, 2017 4:13 AM
  • Folks,

    So today I was able to get on one server that is running fast and another that is acting up and did a Http://localhost/reports/browse to get the main report manager page. The good one ran in about 2 seconds and bad was more like 9 -10 sec....I was then able to get the webhost log entries. You can see below the big difference in times for each step of displaying the initial page. Now the server I have marked as Bad if I come back later and run it it will be as fast as the fast one so there has to be something that causes them to slow down at different times so it seems.

    Running Good Server 1:

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!16!08/11/2017-17:08:03:: i INFO: [q1jun4kc]: ::1: GET /api/v1.0/SystemResources - Response 200 - 0:00:00.1180141

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!66!08/11/2017-17:08:03:: i INFO: [z7rts1eb]: ::1: GET /api/v1.0/ServiceState - Response 200 - 0:00:00.1241501

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1e!08/11/2017-17:08:03:: i INFO: [xbl40mtu]: ::1: GET /api/v1.0/SafeGetSystemResourceContent%28type%3D%27UniversalBrand%27%2Ckey%3D%27stylesheet%27%29 - Response 200 - 0:00:00.1197098

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!16!08/11/2017-17:08:03:: i INFO: [936qqjke]: ::1: GET /api/v1.0/telemetry - Response 200 - 0:00:00.1348866

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!16!08/11/2017-17:08:03:: i INFO: [j661a9ro]: ::1: GET /api/v1.0/powerbiintegration/powerbiintegration.isenabled - Response 200 - 0:00:00.0013865

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!66!08/11/2017-17:08:04:: i INFO: [1ijqottq]: ::1: GET /api/v1.0/ReportServerInfo/Model.SiteName - Response 200 - 0:00:00.1286701

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!4f!08/11/2017-17:08:04:: i INFO: [pgactg64]: ::1: GET /api/v1.0/SystemResources - Response 200 - 0:00:00.1512569

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!16!08/11/2017-17:08:04:: i INFO: [gk46g2jn]: ::1: GET /api/v1.0/notifications - Response 200 - 0:00:00.1390774

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!66!08/11/2017-17:08:04:: i INFO: [jqhtnseq]: ::1: GET /api/v1.0/reportserverinfo/model.GetWebAppUrl - Response 200 - 0:00:00.1138346

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!16!08/11/2017-17:08:04:: i INFO: [cq14ou2q]: ::1: GET /api/v1.0/reportserverinfo/model.GetVirtualDirectory - Response 200 - 0:00:00.123513

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!41!08/11/2017-17:08:04:: i INFO: [zv5jl9y9]: ::1: GET /api/v1.0/SafeGetSystemResourceContent%28type%3D%27UniversalBrand%27%2Ckey%3D%27logo%27%29 - Response 200 - 0:00:00.1604528

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!1c!08/11/2017-17:08:04:: i INFO: [7887gz52]: ::1: GET /api/v1.0/me - Response 200 - 0:00:00.3422501

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!28!08/11/2017-17:08:04:: i INFO: [96tquwku]: ::1: GET /api/v1.0/AllowedActions%28path%3D%40path%29 - Response 200 - 0:00:00.1183615

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!66!08/11/2017-17:08:04:: i INFO: [row0vzao]: ::1: GET /api/v1.0/CatalogItemByPath%28path%3D%40path%29 - Response 200 - 0:00:00.1141244

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!41!08/11/2017-17:08:04:: i INFO: [225rbl5x]: ::1: GET /api/v1.0/catalogitems%28e9bffa54-0571-47d9-baf2-2ea98fb4f655%29/Model.Folder/catalogitems/ - Response 200 - 0:00:00.2044025

    Running Bad Server 2:

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!3!08/11/2017-12:27:55:: i INFO: [z238wyz3]: ::1: GET /api/v1.0/ServiceState - Response 200 - 0:00:00.1219963

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!132!08/11/2017-12:27:57:: i INFO: [unb7i8m1]: ::1: GET /api/v1.0/SystemResources - Response 200 - 0:00:02.6747319

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!136!08/11/2017-12:27:59:: i INFO: [pwb3nkhx]: ::1: GET /api/v1.0/SafeGetSystemResourceContent%28type%3D%27UniversalBrand%27%2Ckey%3D%27stylesheet%27%29 - Response 200 - 0:00:01.6340655

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!132!08/11/2017-12:28:00:: i INFO: [k15npzg8]: ::1: GET /api/v1.0/telemetry - Response 200 - 0:00:00.6217953

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!11d!08/11/2017-12:28:00:: i INFO: [qbj6qjrb]: ::1: GET /api/v1.0/ReportServerInfo/Model.SiteName - Response 200 - 0:00:00.6270867

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!11d!08/11/2017-12:28:00:: i INFO: [pcavt34w]: ::1: GET /api/v1.0/powerbiintegration/powerbiintegration.isenabled - Response 200 - 0:00:00.0018261

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!131!08/11/2017-12:28:00:: i INFO: [6ttfofez]: ::1: GET /api/v1.0/notifications - Response 200 - 0:00:00.1043035

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!131!08/11/2017-12:28:00:: i INFO: [bprifjpk]: ::1: GET /api/v1.0/reportserverinfo/model.GetVirtualDirectory - Response 200 - 0:00:00.6028206

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!12f!08/11/2017-12:28:01:: i INFO: [7tqni5sq]: ::1: GET /api/v1.0/reportserverinfo/model.GetWebAppUrl - Response 200 - 0:00:00.6152785

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!131!08/11/2017-12:28:01:: i INFO: [ks5ubw79]: ::1: GET /api/v1.0/AllowedActions%28path%3D%40path%29 - Response 200 - 0:00:00.6197943

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!12e!08/11/2017-12:28:02:: i INFO: [iguemvr4]: ::1: GET /api/v1.0/CatalogItemByPath%28path%3D%40path%29 - Response 200 - 0:00:01.1421642

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!3!08/11/2017-12:28:02:: i INFO: [310n2yo4]: ::1: GET /api/v1.0/SystemResources - Response 200 - 0:00:02.632707

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!132!08/11/2017-12:28:02:: i INFO: [k770e90l]: ::1: GET /api/v1.0/me - Response 200 - 0:00:02.6931852

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!138!08/11/2017-12:28:03:: i INFO: [k4ds2q44]: ::1: GET /api/v1.0/SafeGetSystemResourceContent%28type%3D%27UniversalBrand%27%2Ckey%3D%27logo%27%29 - Response 200 - 0:00:03.1574461

    Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!138!08/11/2017-12:28:04:: i INFO: [t5dh752o]: ::1: GET /api/v1.0/catalogitems%285edf1786-67ff-44f0-a7da-829b2e628ccb%29/Model.Folder/catalogitems/ - Response 200 - 0:00:02.2538113

     

    Friday, August 11, 2017 9:57 PM
  • Hi phillip786,

    SSRS starts up slowly after a period of inactivity when you try to access the reports page, it might be related to SSRS regularly restarts application domain after specific time period. After the application domain is restarted, then upon first request to the SSRS it needs to load all the settings and it takes quite a long time.

    You could refer to Reporting Service 2012 slow startup and Solving issue with first long starting report on SSRS 2008 for corresponding workarounds, I hope this will help you.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Monday, August 14, 2017 7:36 AM
  • Zoe,

    No this is not it because when it is acting up you go and it is slow...refresh the page it is slow....close browser and reopen and it is slow...go to another browser and it is slow. So that is 4 times to the default page and time is slow on all so not a start up thing. Now when it is running well it will be fast on all browsers and every time you re-fresh the page.

    Monday, August 14, 2017 6:41 PM
  • I found the following that was submitted in Dec that is the same I see...upgraded for ssrs 2014 to 2016 and the report manager performance is bad most but not all the time.

    article

    Tuesday, August 15, 2017 6:33 PM
  • Hi phillip786,

    May I know how is your issue going currently? Did you find something to solve this issue? Whether it is related to the network or thread tied up?

    In addition, it seems that there is no useful suggestions in the thread you provided. Because I can't reproduce your issue, I will ask other engineers to discuss this issue, if we have solution, I will inform you as soon as possible.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, August 18, 2017 3:00 AM
  • Zoe,

    Yes we finally found the issue....our new servers are Win2012 R2 VMs and for http traffic you have to disable the Receive Side Coalescing = disabled for both IP4 and IP6 on the network adapter...it is in the Advance tab of the network configuration. If you don't it will queue traffic up before processing leading to the perceived slow performance.  Our Citrix VM tech had seen it before and we were able to set this without reboot and things are working fine now.

    Here is a article about it jump down to the section on Receive Segment Coalescing (RSC)

     http://lifeofageekadmin.com/network-performance-vmxnet3-windows-server-2012-r2/

    • Marked as answer by phillip786 Sunday, August 20, 2017 1:43 AM
    Sunday, August 20, 2017 1:43 AM
  • Not working for me.

    Set Receive Segment Coalescing = disable  for IPv4 and IPv6. in vmxnet3 Ethernet Adapter properties.


    Any suggestion?


    Monday, October 7, 2019 7:01 AM