Max Concurrent Threads for SRS1.0 SP2

How many concurrent threads will SRS 1.0 sp2 spin up to handle concurrent subscriptions? Is the alogrythm documented anywhere? It appears that changing the MaxQueueThreads from zero(Default Value) should have an impact on the number of threads. If so are there any MSFT best practices around changing this setting?

Thanks

If MaxQueueThreads = 0, SSRS will spin up as many threads as it thinks it needs to process all the subscriptions -- but I've never seen (internally or externally) this decision making process documented.

There also is no "patterns and practices" type guidance on changing this value...that being said, lots of small reports generally do better with a higher number here (so we can run multiple, quickly completing reports at the same time), while large reports like a smaller value (because we can run fewer big reports at the same time without RAM contention issues, I guess).

I played around with some "subscription tuning" scenarios a while back...You an read about what I learned here:

http://blogs.msdn.com/bimusings/archive/2005/08/17/452865.aspx

|||

After a little research, it looks like the main inputs into MaxQueueSettings are # CPUs and amount of free RAM...Thinking more about this, I suppose you could just use perfmon and watch the number of threads reportserverservice.exe and/or w3wp.exe spins up during heavy subscription activity along with RAM they utilize...then play with MaxQueueSettings

Matrix Width

Is there a way to ensure a matrix layout does not expand horizontally
past a certain point (i.e. page)? There appears to be an option to try
and fit the matrix on one page but that doesn't stop it going over
multiple pages in the horizontal direction.
ThanksOn Apr 16, 5:57 pm, "gommo" <colin.gou...@.gmail.com> wrote:
> Is there a way to ensure a matrix layout does not expand horizontally
> past a certain point (i.e. page)? There appears to be an option to try
> and fit the matrix on one page but that doesn't stop it going over
> multiple pages in the horizontal direction.
> Thanks
Outside of the option you mentioned, as far as I know, there is
nothing else available. Sorry I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Apr 16, 5:57 pm, "gommo" <colin.gou...@.gmail.com> wrote:
> Is there a way to ensure a matrix layout does not expand horizontally
> past a certain point (i.e. page)? There appears to be an option to try
> and fit the matrix on one page but that doesn't stop it going over
> multiple pages in the horizontal direction.
> Thanks
It will cut off additional data, but you could filter the outermost
column group on {group expression} by "Top N" ={max columns}, i.e for
at most 5 columns grouped on myID you would have a group filter for
myID by 'Top N' with value of '=5'.
Hope this helps ~ K