Geek asks and answers

Does SSRS suggest subscriptions that start simultaneously?

If you have several subscribers to the reports that will be launched at the same time, will they all start at this time and will be executed simultaneously? That is, if you have too many reports scheduled at a certain time, they run the risk of using too many system resources and cannot?

Are shared subscriptions differently divided?

I am interested in the answer to this version for any version of SSRS, since my organization manages environments with SSRS 2005, 2008, 2008 R2, and 2012.

I tried searching MSDN and Google, but I could not find anything specific. I assume that separate schedules run simultaneously and run simultaneously (compete for system resources), since SSRS is designed to run reports on demand at the same time. But I could imagine scenarios in which a general subscription can pause report queues.

Is there a way to globally limit the number of simultaneous report runs that can take place? I know that you can limit it for each user in the RSServerConfig file.

+3
source share
2 answers

I found some interesting information that explains how SSRS handles scheduled subscriptions:

When creating a subscription, several things Server are added to RS:

  • ...

  • Schedule ReportSchedule...

  • SQL Server...

, :

  • SQL Server ...

  • RS (2 ), Event...

  • , ...

: : II...

( ...) . (, RS 4 .)

, - ...

+4

RsReportServer.config MaxQueueThreads. 1 2, SSRS. , .

, . doco:

http://msdn.microsoft.com/en-us/library/ms157273.aspx

+4

More articles:


All Articles