I believe what you may be looking for is within this KB article. Configure Workbook Performance after a Scheduled Refresh
You can set the threshhold to what you want. We set it to 10.
tabadmin set backgrounder.externalquerycachewarmup.view_threshold 10
There is a non extract task " Generate Sheet Image for View " which generates an image of the report, whenever there is an issue with the DB site this task runs for more than 200min and fails. The goal here, is to set a time limit for less that. That way it is not consuming the server resources and running forever.
I am looking for a set tabadmin command that can minimize that time.
Adam Adam wrote:
I am trying to reduce the query time limit for one of the non extract task " Generate Sheet Image for View "
Can anyone please share the proper tabadmin command to do that.
There isn't one specifically. Try playing with vizqlserver.querylimit.
There's some confusion here...which one do you want:
- Have the View execute faster?
- Have the View terminated if it takes longer than X number of minutes?
Would like the task to be terminated if it takes longer than X number of minutes?
Okay, thanks. Then what I've done you'll find useful. Here's a snippet from my Tableau Server setup script:
REM Seconds beyond the query limit before a task is canceled, in seconds (300 seconds = 5 minutes) tabadmin set backgrounder.extra_timeout_in_seconds 300 REM Longest allowable time for completing an extract refresh, in seconds (10800 seconds = 3 hours) tabadmin set backgrounder.querylimit 10800 REM From Mark Wu, item #5, http://enterprisetableau.com/how-to-reduce-tableau-extract-waiting-time-50/ tabadmin set backgrounder.sort_jobs_by_run_time_history_observable_hours 36 REM Tasks to be canceled if they run longer than they should tabadmin set backgrounder.timeout_tasks refresh_extracts,increment_extracts,subscription_notify,single_subscription_notify
Each of these items can be found here: tabadmin configuration options
The third item (lines 7 & 8 above) is NOT necessary but I included it because it is helpful in the whole extract process.
tabadmin set command
tabadmin set command