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.

6
  • 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, 2016 at 15:54
  • @SqlRyan Unfortunately no.
    – SQLChao
    Jun 30, 2016 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, 2016 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, 2017 at 13:04
  • @Pepys - - I have the same exact issue. Have you managed to resolve it ? Nov 5, 2018 at 8:52

1 Answer 1

-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 and acknowledge that you have read and understand our privacy policy and code of conduct.

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