Extract-based Workbooks Slow to Load After Upgrading to Tableau Server

Published: 13 Mar 2017
Last Modified Date: 05 Oct 2019


After upgrading to Tableau Server 10.0 - 10.2, workbooks with large extracts or many extracts and schedules might experience performance issues. 



  • Tableau Server 10.0 - 10.2
  • Extracts


Important: Do not attempt the below steps in Tableau Server 10.5 or newer versions. With the introduction of the new Tableau Data Engine processes, they are unnecessary and will not work.

Increase the number of Data Engine Processes on computers running Tableau Server 

For each computer in the Tableau Server cluster with Data Engine process, make sure there are at least 2 Data Engine processes. Any computer that has only one Data Engine process should be modified to include at least 2 Data Engine processes.

Additional Data Engine Optimizations

  • For 10.0.0 - 10.0.4 and 10.1.0 - 10.1.2, increase the Data Engine processes to 3 or 4. Note: CPU load should be monitored closely as part of the configuration change.
  • For 10.0.5 - 10.0.7 and 10.1.3 - 10.1.5, increase the Data Engine processes to 3 or 4 and run the steps below for optimal performance. 

Optimization of data engine string:

  1. On the computer running Tableau Server, open the Command Prompt window as an administrator and run the following command to change the directory to the Tableau Server bin folder:
cd "C:\Program Files\Tableau\Tableau Server\[version]\bin"
  1. At the command prompt, run the following commands in order:
    • tabadmin set dataengine.optimize_icu true
    • tabadmin config
    • tabadmin restart
For 10.0.8 and 10.1.5, run the "Optimization of data engine string" steps above, but do not increase the Data Engine processes beyond 2. 

For 10.0.9, 10.1.6 and newer versions, the data engine string optimization occurs by default and these additional steps are not necessary.

Other Optimizations for upgrades to major versions

As with any major version upgrade, we recommend optimizing existing workbooks and extracts for the new functionality.



In Tableau Server 10, Tableau reduced overall latency and throughput for views. This optimization can cause increased use of Data Engine. The increased volume of requests may result in some performance delays if the configuration is unchanged in Tableau Server 10.0-10.2. No configuration changes are needed in Tableau Server 10.3 or later.

Additional Information

Changes to Data Engine will increase CPU consumption during peak extract use. This is the expected result of the optimizations in Tableau Server 10.0-10.4. Review and test these changes to understand the impact to performance and CPU load before applying these changes to production.


Discuss this article... Feedback Forum
Did this article resolve the issue?