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.
No comments:
Post a Comment