Data driven subscriptions and scale-out?

Say I have a scheduled data-driven reports that will product pdf files (a lot). Will this benefit
from scale-out?

I.e., having one SQL Server with the reporting services databases and several
servers with the reporting services windows service and web services.

I have this feeling that when the Agent job starts, it will do this in a matter so that all the
reports for this job will be processes on only one RS server? Or perhaps I can partition this
myself, where I somehow have several jobs, each job connecting to a different server generating a
subset of the reports?

No replies so I tested it myself. After lots of hassle to get scale-out installed, but I finally got it working. And the answer is Yes.

I processed a data-driven subscription to generate bunch of pdf files and CPU went up on both RS machines. Also looking in the RS log files I can see that each RS machine processed different PDF files.

Data driven subscriptions and scale-out?

Say I have a scheduled data-driven reports that will product pdf files (a lot). Will this benefit
from scale-out?

I.e., having one SQL Server with the reporting services databases and several
servers with the reporting services windows service and web services.

I have this feeling that when the Agent job starts, it will do this in a matter so that all the
reports for this job will be processes on only one RS server? Or perhaps I can partition this
myself, where I somehow have several jobs, each job connecting to a different server generating a
subset of the reports?

No replies so I tested it myself. After lots of hassle to get scale-out installed, but I finally got it working. And the answer is Yes.

I processed a data-driven subscription to generate bunch of pdf files and CPU went up on both RS machines. Also looking in the RS log files I can see that each RS machine processed different PDF files.

Data Driven Subscription Not Available

I am trying to create a data driven subscription. However, on the
Subscriptions tab for the reports the New Data-Driven Subscription selection
is not present. Only the New Subscription selection is present. I can
create regular subscriptions but need to create a data driven subscription.
Is there something in the config file that needs changed to enable data
driven subscriptions?Do you have Standard or Enterprise. Data driven subscriptions is a
Enterprise feature.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>I am trying to create a data driven subscription. However, on the
> Subscriptions tab for the reports the New Data-Driven Subscription
> selection
> is not present. Only the New Subscription selection is present. I can
> create regular subscriptions but need to create a data driven
> subscription.
> Is there something in the config file that needs changed to enable data
> driven subscriptions?|||Data driven subscriptions are only available with SQL Server Enterprise
Edition.
Are you running Standard?
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>I am trying to create a data driven subscription. However, on the
> Subscriptions tab for the reports the New Data-Driven Subscription
> selection
> is not present. Only the New Subscription selection is present. I can
> create regular subscriptions but need to create a data driven
> subscription.
> Is there something in the config file that needs changed to enable data
> driven subscriptions?|||I thought I was running Enterprise everywhere but on this server it is only
the Standard edition. We are planning on upgrading to SQL Server 2005 1Q06 -
what version of it will I need to have?
Thanks for your help.
Blaine
"Bruce L-C [MVP]" wrote:
> Do you have Standard or Enterprise. Data driven subscriptions is a
> Enterprise feature.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Blaine" <Blaine@.discussions.microsoft.com> wrote in message
> news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
> >I am trying to create a data driven subscription. However, on the
> > Subscriptions tab for the reports the New Data-Driven Subscription
> > selection
> > is not present. Only the New Subscription selection is present. I can
> > create regular subscriptions but need to create a data driven
> > subscription.
> > Is there something in the config file that needs changed to enable data
> > driven subscriptions?
>
>|||Data driven subscriptions is still an enterprise feature in RS 2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:3C1F63FF-EFBB-469D-9A1E-F27AE5A48165@.microsoft.com...
>I thought I was running Enterprise everywhere but on this server it is only
> the Standard edition. We are planning on upgrading to SQL Server 2005
> 1Q06 -
> what version of it will I need to have?
> Thanks for your help.
> Blaine
> "Bruce L-C [MVP]" wrote:
>> Do you have Standard or Enterprise. Data driven subscriptions is a
>> Enterprise feature.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Blaine" <Blaine@.discussions.microsoft.com> wrote in message
>> news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>> >I am trying to create a data driven subscription. However, on the
>> > Subscriptions tab for the reports the New Data-Driven Subscription
>> > selection
>> > is not present. Only the New Subscription selection is present. I can
>> > create regular subscriptions but need to create a data driven
>> > subscription.
>> > Is there something in the config file that needs changed to enable data
>> > driven subscriptions?
>>