6 Reports
100% CPU usage for two hours when one user is connecting to a published data source from Tableau Desktop.
Created
Found in Release
2022.1.21+
Last Updated
Reference ID
W-17128807
Summary
100% CPU usage for two hours when one user is connecting to a published data source from Tableau Desktop.
Steps to Reproduce
- Open a workbook in Tableau Desktop that has is using a Tableau Server published data source
- Select a sheet
- Drag and drop measurements that will generate a CROSS JOIN calculation in the published data source.
- Check the CPU usage of the hyper node it will go 100% until SRM kill the process.
Workaround
The workaround below may help achieve the expected behaviour:
tsm configuration set -k native_api.logical.query.rewrite.disable -v Join:PostFuse --force-keys
tsm pending-changes apply
Note that after the Join:PostFuse rewrite rule has been disabled, the performance of queries that use CROSS JOIN may be slower than before the upgrade. (This includes view loads connecting to these data sources, as well as extract refreshes.) Further testing would be needed to confirm this impact as the performance will vary depending on the query executed.
6 Reports