We have a collection of reports that are deployed to several environments. The reports work as expected in all environments except for one. In this particular environment, the reports - which normally take a couple seconds to load - take 2-3 minutes to load the interface. It seems like the more dataset-driven drop down parameters the report has, the longer it takes to load. When I look at ReportServer..ExecutionLog3, I can see that the Dataset Executions are taking 6+ seconds to load each, whereas these take a few ms in every other environment. However, when I have SQL Profiler running, I can see that the batch containing the dataset executed in less than 100ms. So there's over 5 seconds of just waiting around. I figure this has to be something environment specific. I've brought in our network admin to run wireshark, as we were thinking it might have something to do with AD authentication over a slow link, but he didn't see anything unusual.
Any ideas? Our client is really starting to get unhappy about this. Thanks in advance.