Home Forums Reporting Services Reporting Services Reporting Services From a Data warehouse - Bottleneck On Every Month RE: Reporting Services From a Data warehouse - Bottleneck On Every Month

  • The only suggestion I can offer at this point is trying to stagger the SSRS subscriptions to minimize the concurrency. Maybe if just five of them fire off each minute, that will give them a chance to finish before the next batch runs a minute or two later. There may also be hardware/DB configuration options open to you, but I don't know that side of the SQL world. Hopefully a more informed member of the community will have more info.