KNOWLEDGE BASE

Workbooks Slow to Load After Upgrading Tableau Server


Published: 13 Mar 2017
Last Modified Date: 18 May 2017

Issue

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

 

Environment

  • Tableau Server 10.0, 10.1, 10.2
  • Extracts

Resolution

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.

 

Cause

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.

Additional Information

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

 

Did this article resolve the issue?