6 Replies Latest reply on Jun 30, 2017 9:15 AM by Mark Wu

Scaling Tableau - Set Extract Priority Based on Duration

Mark Wu Dec 5, 2016 8:41 PM

Are you facing the situation that your Tableau server backgrounder jobs have much longer delay during peak hours ?

I managed to reduce 50% extract waiting time after increased priority for all extracts with duration below median runtime. Read my recent blog @ Scaling Tableau (2/10) - Set Extract Priority Based on Duration - Silicon Valley Enterprise Tableau User Group

Please share your tips on different ways to increase extract efficiency.

1. Re: Scaling Tableau - Set Extract Priority Based on Duration

Nick Roush Dec 6, 2016 6:35 AM (in response to Mark Wu)

This is awesome Mark! I have been manually prioritizing based on time and it is a huge pain when you have thousands of extracts to update.
Like Show 0 Likes(0)

Actions
2. Re: Scaling Tableau - Set Extract Priority Based on Duration

Jeff Strauss Dec 6, 2016 7:13 AM (in response to Mark Wu)

thanks Mark! I never knew of the sorting feature, is it new?
Like Show 0 Likes(0)

Actions
3. Re: Scaling Tableau - Set Extract Priority Based on Duration

Obed Tsimi Jun 29, 2017 7:17 AM (in response to Mark Wu)

Thanks much Mark Wu ,

Very helpful.

Just a few questions for you.

How many backgrounders do you have and what version of Tableau server are you running?
Like Show 0 Likes(0)

Actions
4. Re: Scaling Tableau - Set Extract Priority Based on Duration

Andrew Macey Dec 6, 2016 4:24 PM (in response to Mark Wu)

I still find a backgrounder utilization viz very useful for identifying offending sites Re: Viewing Tableau 9 Background Tasks Queued Getting users with long running jobs to use a Serial rather than Parallel schedule also helps to stop them hogging all the backgrounders.
Like Show 0 Likes(0)

Actions
5. Re: Scaling Tableau - Set Extract Priority Based on Duration

Mark Wu Dec 6, 2016 7:35 PM (in response to Andrew Macey)

I am on v10.0 with about 3,000 extracts per day and 40 backgrounders. tabadmin set backgrounder.sort_jobs_by_run_time_history_observable_hours must be a v10.0 new feature. I have not seen this set option at v9.2 admin guide or v9.3 admin guide but it shows the 1st time on v10 admin guide. I have not seen Tableau advertises this feature anywhere in official v10 new feature list. I think that this is another great big brother v10 new feature similar as Desktop license reporting. One more good reason to upgrade to v10 if you have not done so yet.
Like Show 0 Likes(0)

Actions
6. Re: Scaling Tableau - Set Extract Priority Based on Duration

Mark Wu Jun 30, 2017 9:15 AM (in response to Obed Tsimi)

60 backgrounders on V10.2 now with about 6,000 extracts/day
Like Show 1 Likes(1)

Actions