2

I have a SQL Server 2014 test box with SSRS installed. The site loads ok and reports are quick. When I try to go to Subscribe the page takes over a minute to load. From there if I pick a schedule it also takes minutes to load. This is a fresh box with nothing else installed. There's not antivirus installed.

The box has 2 x xeon @ 2.66 and 6GB of memory. I'm the only user on this box as it is just for testing.

  • Did you ever find a solution to improving the speed here? We're deploying SSRS 2016 in native mode and the page to manage subscriptions is painfully slow (and we only have a dozen or so subscriptions set up at this point). – SqlRyan Jun 30 '16 at 15:54
  • @SqlRyan Unfortunately no. – SQLChao Jun 30 '16 at 15:58
  • That's too bad - the subscription page takes upwards of 5-6 seconds to load and there are virtually no subscriptions on the server yet since we're still pre-deployment. I suppose it says something that there's a $700 third-party product on the market specifically design to help you manage and update SSRS subscriptions... – SqlRyan Jun 30 '16 at 16:50
  • We have SSRS 2016 and it takes 10 minutes when Editing a subscription (the only one)... what on earth is going on – Pepys Mar 10 '17 at 13:04
  • @Pepys - - I have the same exact issue. Have you managed to resolve it ? – Halt_And_Catch_Fire Nov 5 '18 at 8:52
-1

This may be too late but try looking at the File settings for ReportServer and ReportServerTempDB, just like you normally would through SSMS on the instance. They may be defaulted to a few MB with a 1MB autogrowth.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.