On this weblog, I’m going to discover what the completely different thread settings in PBRS (Energy BI Report Scheduler from ChristianSteven Software program) are, and the way they have an effect on reporting scheduling and rendering. Earlier than moving into that although, it is very important perceive the primary variations between threads and processes.
Threads and Course of in PBRS
A course of, within the easiest phrases, is an executing program (an exe in Home windows). A number of threads run contained in the context of a course of. A thread is the fundamental unit to which the working system allocates processor time. A thread can execute any a part of the method code, together with components at the moment being executed by one other thread. Threads permit a single course of to hold out a number of duties on the similar time.
Each course of runs in its personal separate reminiscence area and usually a fault in a single course of doesn’t have an effect on some other course of.
In relation to PBRS, a few of the “thread” settings consult with processes and we are going to discover these beneath.
Multi-Threading for Scheduling
Out there within the Choices window, that is the primary multi-threading setting that you’ll probably encounter when establishing your PBRS scheduler. This setting permits you to allocate as much as 8 threads, however it’s referring to Processes. What this setting impacts is the variety of schedules that can processed concurrently by PBRS.
To have a look at an instance, say you’ve got 6 schedules all resulting from run at 9am; when the time involves run the schedules, PBRS will begin 6 sub-processes and every one will probably be devoted to processing a single schedule. If this setting was switched off, a single course of would run all 6 schedules sequentially.
Multi-Threading for Energy BI Web page Rendering
This setting can be accessible in Choices and permits you to decide what number of pages are rendered on the similar time per schedule. As above, this feature can be referring to the variety of processes that will probably be invoked to render the assorted pages of a Energy BI report. If this setting is ready to, say 10, it signifies that a single PBRS course of operating a Energy BI report containing 5 pages, will invoke 5 situations of the pbrsrenderer.exe course of with every one devoted to rendering a single web page of that report.
This setting is efficient on a per schedule foundation which means two schedules operating on the similar time to render 5-page stories will find yourself invoking 10 situations of the pbrsrenderer.exe course of. The system will nonetheless cap the full variety of the pbrsrenderer.exe processes on any system to 100.
Multi-Threading for Knowledge-Pushed Schedules
When establishing a data-driven schedule, you even have an choice to specify what number of threads will probably be used course of the schedule. Not like the opposite settings, this setting is referring to precise inside threads and never processes.
The setting determines what number of rows within the data-driver will probably be processed asynchronously in the course of the report rendering part of schedule execution.
While you put all these settings collectively, you possibly can start to see how versatile and highly effective PBRS is in permitting you to maximise the processing energy of your server.
PBRS Report Scheduler for Energy BI