Should be @ simple questions however many - I was looking at execution mode available while creating tableau schedule ( Extract refresh/subscription ) . So thought to learn its basics .
There are two modes available
a. Parallel - Use all available background process for this schedule
b. Serial - Limit this schedule to one Background process .
Now let me explain my questions with example -
- I created a schedule S1 on tableau server with task type as Extract refresh with execution mode as Parrallel daily at 7 AM . Now a site user opt for it to use this scheudle to refresh his/her extract refresh at 7AM everyday .so now we have a task attached to this S1 let's call it as T1 .Now Keep in mind I have 4 Backgrounder process running on my server cluster lets name these process BG1 ,BG2,BG3 & BG4 (below diagram )
so my question is when next day clock reach to 7 AM ,will T1 processed by only one of Background process like BG1 OR BG2 OR BG3 OR BG4( because BG is a single threaded process) or by all backgrounder process will work together to process T1 like BG1 AND BG2 AND BG3 AND BG4.? ( because we selected it to run parrallel)
- Now second scenario - I created a schedule S1 on tableau server with task type as Extract refresh with execution mode as serial . Now 2 different users opted for that schedule to refresh their data at 7 AM. So now we have 2 tasks attached to this S1 Schedule let's call these tasks as T1 & T2 .Now keeping in mind above diagrame
My question is when next day clock reach to 7 AM ,
a . will T1 & T2 both get executed simluteniously as we have 4 backgrounder process so likewise T1 will process by BG1 and T2 will get process by BG2 ?
b. WIll T1 process first as we selected serial execution ? If yes then will all the Backgrounder process (BG1,BG2,BG3&BG4) T1 or only one of BG process will process it and once T1 completed T2 will get proccessed .
- Third scenario - I created 2 schedules S1 and S2 and both are extract refresh schedule, now assume S1 has T1,T2 & T3 tasks and S2 has Ta,Tb & Tc tasks and both are schedule to run next day at 7 AM ( consider S1 is daily and S2 is weekly at 7 AM)
My question is -
a. How these tasks T1,T2,T3,Ta,Tb & Tc will process on BG1,BG2,BG3& BG4 when execution mode of S1 & S2 is Serial
b. How these tasks T1,T2,T3,Ta,Tb & Tc will process on BG1,BG2,BG3& BG4 when execution mode of S1 & S2 is Parrallel.