Have a really strange problem with Reporting Services 2008 RTM. If I try to go to the main URL http://servername/Reports/ in IE it takes a long time to load (15-20 seconds), same thing happens if I navigate directly to a report. The rest of that session in IE is fine. At first we thought it was the worker process just shutting down and the first load taking a while, but if we close IE completely, and reopen IE it does the same thing. The really strange part is if I use a different browser (chrome or ff), or use the IP address of the server in IE, it loads instantly without any issues. Seeing some really odd things in the HTTP SSRS log as well. This only happens when I first load the SSRS URL in IE. I see a bunch of requests to the RS webservices, under the user credentials, but it shows localhost (::1) as the user's IP address. So I am hitting the SSRS server remotely from a desktop, but while it is loading (the 15-20 seconds that it is just stalled) I see these requests hitting and then finally see the GET /Reports/Pages/Folder.aspx. Any thoughts? SSRS is configured to only use NTLM: <Authentication> <AuthenticationTypes> <RSWindowsNTLM/> </AuthenticationTypes> <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel> <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario> <EnableAuthPersistence>true</EnableAuthPersistence> </Authentication> Here is the HTTP logs: 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 820 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 334 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 396 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 820 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 335 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 397 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 859 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 334 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 396 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 966 16 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 334 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 396 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 923 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 334 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 396 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 820 15 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 341 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 403 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 834 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 333 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 395 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 881 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 334 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 396 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 820 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 340 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 402 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 943 16 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 340 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 402 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 933 15 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 334 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 396 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 820 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 340 0 1.1 localhost - - - 05/04/2012 15:39:20 - ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 401 402 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username ::1 20480 localhost POST /ReportServer/ReportService2010.asmx 200 919 0 1.1 localhost - - - 05/04/2012 15:39:20 domain\username 192.168.9.138 20480 SRSServerName GET /Reports/Pages/Folder.aspx 200 1174 109 1.1 SRSServerName - - -

Hi, I can't see anything obvious from the logs. How much available RAM do you have immediately before you open SSRS within IE? Do you have the other SQL Server services running off the same server box, e.g. SSDE, SSAS and SSIS?If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood

Kieran, Thanks for the response. SSRS is collocated with the Database Engine on this server so there isn't a lot of free memory available. We could look to limit the ram the database engine would take up but it seems like SSRS performs fine in browsers other than IE (and actually works fine in IE as well after the initial load). We havent really looked at server performance issues as of yet since everything does seem to run fine. It really seems like some type of weird interaction with IE (either authentication or something else) that is causing things to load slowly on the first load. Any thoughts on the delegated call back to the Reporting Service Web Service? To be honest I'm not even sure how this is happening, we are running NTLM so it can't really be delegating the users credentials (kerberos) but somehow the local SSRS server is calling back to itself (or at least it looks that way in the logs since it says the host name is localhost) with the user's own credentials. This only happens when loading in IE for the first time.

Hello mrg_ Report Manager requires extra time to load the initial page. Additional wait time is required to start ASP.NET. After the initial page opens in the Web browser, subsequent application pages open much faster. Here is an article about troubleshooting Report Manager problems for your reference, please see: http://technet.microsoft.com/en-us/library/ms345220.aspx Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Bin Long TechNet Community Support

Bin, I understand that RS might have to load ASP.NET during the initial server load but everything is already loaded on the server when we see this problem. It is anytime any user loads a new IE 9 browser and tries to access SSRS in anyway. Looking in the logs SSRS is already started. If I load SSRS in any other browser it loads fast and fine. If I close out of IE and go back to SSRS the first time it loads takes 20-40 seconds. Looking in the HTTP logs it looks like it is doing some weird loopback to the reportingservice webservice which is what is taking the extra time with IE. If I load SSRS in another browser I don't see this behavior. It seems like there is just something odd going on when IE specifically accesses SSRS. Thanks for taking a look, any other thoughts?

Can you upgrade the RAM on the server? My gut feeling is that this is worth a try. I had a perfomance increase in SSRS when upgrading from 32Gb to 96Gb and as I guess you are already aware configuring the database engine so the database engine doesn't eat up all the RAM. Also with reference to the link Bin provided; - http://technet.microsoft.com/en-us/library/ms345220.aspx Do you always leave an SSRS portal running in IE on your server? I tend to do this it may help. I'd also give this a try; - http://stackoverflow.com/questions/838318/how-to-keep-asp-net-assemblies-in-appdomain-alive If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood

Kieran, I am a little hesitant to just throw hardware at this issue since everything loads fast and fine with other browsers (chrome, firefox, etc) and IE 9 even loads fine if I go after just the IP address of the server (not the DNS Name). That really leads me to believe it is something of weird authentication issue or some other security check that is happening because of IE. As far as the idle time settings in the articles you sent, right now we have the default set in the SSRS config for 720 minutes (no iis since this is SSRS2008). We see this issue anytime we load IE so it isn't slow because of the initial load, there is something stalling the first request from a user in IE. Thanks!

OK thanks for your feedback. I agree this is wierd if you get the performance issue entering the server name but not the IP address. So as I guess you have already identified this appears to be an issue with your Domain Name System which only manifests with SSRS 2008 R2 and IE 9. I'll continue chipping away at this and see if I can find anything. Please continue to update this thread is you learn more about this issue to avoid duplication of effort.If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/kieranpatrickwood

Kieran, Where i work we just received new pc's with Windows 7 and IE9. Ever since then our SSRS reports (2005 server) have ran extremely slow. It's not even the amount of time it takes for them to run that's the issue, it's even how long it takes for the paramters to show at the top of the screen. That will take sometimes up to a minute to show up. I hadn't even thought to try Chrome, but after reading this list, i tried that as well. Just like you found, everything works just like it did under IE7. No lag for the parameters to show, no slow performance from the reports. Were you ever able to find a resolution to this issue?

Nater_Tater, We are still seeing this issue but unfortunately have not had much time to additional investigation on it. In your situation, does IE perform faster after the first report is loaded? For us it only seems like it is that first report that the IE session opens that is lagged, the rest are fine. But if you close IE and open it again, you experience the same lag on the first report. I might try to pick up troubleshooting this again next week so I will let you know if I come across anything.

I'm still chipping away at this sort of issue as well as multi-tasking with a lot of other stuff. However I am now focusing more on optimising the SSRS report design rather trying to speed up how the browser works. Although I do appreciate and share the frustration caused in some browsers being faster than others I still find that the most pragmatic solution is to focus on optimising the SSRS report design. http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/18840d8f-8efc-4f2c-8e98-c2a21cf943df If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com/ http://uk.linkedin.com/in/kieranpatrickwood