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

  • Hi,

    Many thanks for the reply.

    Yes.. There are several SQL jobs running at the same time where the subscriptions were scheduled.

    Also many users will also query the tables in data warehouse where the subscriptions are also querying the same tables.

    for example, if i am scheduling 110 + ssrs subscriptions at 02:00 AM UK time, those subscriptions were delivered around 08:00 AM UK time...may i know why ?...

    I have been facing the issues at regular times....not for 02:00AM..this issue persist for all timings.....

    Can you please help me to run my ssrs subscriptions quickly ??

    At the moment we can run the reports... But performance had been poor.

    Can u help me??