Post reply

Limit on number of reports running

  • January 31, 2012 at 12:25 pm

    #256019

    Hello,

    I just wanted to ask you if we can set a limit on number of reports running on SSRS i.e. like limit the report running to 20 or 30.

    I’m asking this because when there are 90 or 100 reports running, they all are queued up and they are taking very long to complete.

    Thanks

  • January 31, 2012 at 12:33 pm

    #1440909

    Are they all competing for the same data resources (tables, views, etc.)??

    This is a difficult question to answer with anything but it depends.

    -It depends on your hardware

    -It depends on the queries the reports are running

    -It depends on other load and I/O factors on the server at the time

    etc.

    I think the practical answer is that the limit for your situation is when you notice an impact on performance.

  • January 31, 2012 at 12:45 pm

    #1440921

    They use different data source and tables. I was looking for something like crystal report has limit of running 20 reports at a time.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply