Sunday, June 12, 2022
HomeBusiness IntelligencePBRS Threads and What They Imply

PBRS Threads and What They Imply

On this weblog, I’m going to discover what the totally 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 stepping into that although, it is very important perceive the primary variations between threads and processes.

PBRS Power BI Delivering More BI With Less BS

Threads and Course of in PBRS

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 essential unit to which the working system allocates processor time. A thread can execute any a part of the method code, together with elements presently 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 house and usually a fault in a single course of doesn’t have an effect on another course of.

In terms of PBRS, a few of the “thread” settings seek advice from processes and we’ll discover these beneath.

Multi-Threading for Scheduling

Obtainable within the Choices window, that is the primary multi-threading setting that you’ll possible encounter when organising your PBRS scheduler. This setting means that you can 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 as a consequence of run at 9am; when the time involves run the schedules, PBRS will begin 6 sub-processes and each will likely 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 setting in PBRS


Multi-Threading for Energy BI Web page Rendering

This setting can also be accessible in Choices and means that you can decide what number of pages are rendered on the similar time per schedule. As above, this feature can also be referring to the variety of processes that will likely be invoked to render the varied pages of a Energy BI report. If this setting is about to, say 10, it implies that a single PBRS course of operating a Energy BI report containing 5 pages, will invoke 5 cases of the pbrsrenderer.exe course of with each 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 reviews will find yourself invoking 10 cases of the pbrsrenderer.exe course of. The system will nevertheless cap the whole variety of the pbrsrenderer.exe processes on any system to 100.

Power BI rendering with PBRS


Multi-Threading for Information-Pushed Schedules

When organising a data-driven schedule, you even have an choice to specify what number of threads will likely be used course of the schedule. Not like the opposite settings, this setting is referring to precise inner threads and never processes. 

The setting determines what number of rows within the data-driver will likely be processed asynchronously through the report rendering part of schedule execution.

Multi-threading for Data-Driven schedules in PBRS


Once you put all these settings collectively, you may 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


JN1290 - PBRS promo video 1080p


Get Options PDFBegin Free Trial



Please enter your comment!
Please enter your name here

Most Popular

Recent Comments