Advanced Deployment – Turn off Ask Data for large data source

Ask Data’s entry point is the published data sources. By default, Ask Data is ON  and Ask Data defaultData source analysis (Ask Data indexing) is  triggered by user request for ALL published data sources.

What it means is that even the user did not intend to use Ask Data when come to the published data source (like to see refresh schedules, or check when it was refreshed last time, etc), it will still trigger Tableau Ask Data Index right away that is unnecessary server actions.

The above behavior may not be a big deal for small published data sources but can make difference for large published data sources, specially if your server has hundreds or thousands of published data sources.

How to avoid unnecessary Ask Data indexing for large published data sources?

The best option is to turn Ask Data off by default for those very large published data sources.  How?

UPDATE datasources
SET nlp_setting = ‘disabled’
WHERE size > ‘400000’

What is does is to turn off Ask Data for those published data sources   with size more than 400Mgb (or whatever size you decide).

Why this approach?

  1. Data source owner can always turn Ask Data on if they do want to use Ask Data. This is done by self-service
  2. You are not turning off Ask Data for whole server which is doable but need tsm restart to change it back.
  3. For those who may not know, the following command will turn whole server’s Ask Data off
    tsm configuration set -k features.NLBox -v false
    tsm pending-changes apply
  4. The following commend will turn whole server’s Ask Data on
    tsm configuration set -k features.NLBox -v true
    tsm pending-changes apply
  5. I am not aware commend to turn on/off for a site

Re-Cap: If you are concerned Ask Data always consumes server resources when mouse over to any published data sources even the user doesn’t intend to use Ask Data. Server Admin can turn Ask Data off for large published data source by default with one simple. Pls note that it is not supported by Tableau.

 

3 thoughts on “Advanced Deployment – Turn off Ask Data for large data source”

  1. Hi Mark, If we consider to turnoff Ask data on whole server . Can the datasource owners still turn on at datasource level ?

Leave a Reply