Very interesting post - in every instance I've seen, hyper performs better than TDE.
What size is your data (how many columns & rows) ?
What do your dashboards look like (supply a screenshot and hash out anything confidential) ?
What is your underlying database ?
And on the hardware side ...
What is the spec's for your server ?
How many users do you have ? (etc)
Really appreciate your quick response.
We are using Tableau Published Data sources (Extract -refreshing on scheduled bases)
The back-end database in Oracle.
The Dashboard contain, 4 views - 1 stacked bar chart(colored by accounts), 3 tables - with 10 columns each. 10 filter selections.
We are using three datsets to created this dashboard and using blending concept to fetch the fields.
Primary table - 9958 records, (40 columns)
Secondary tables - 140414 records (40 columns) , 7931 records (25 columns)
I don't have complete details of hardware but the hardware used for the tableau server is way far good that what tableau is recommended. Ideally, hardware was not an issue. Currently, for that dashboard, the power users are just 10 members.
So the data is pretty small as well. but 10 filters will slow things down - are they all set to "relevant values only" ?
Based on the other stats you've mentioned, have you done a performance recording of the workbook to see where the time is being spent ?
Following on from what Chris said above, I'd also look at your blend tables and uncheck any unnecessary blending links - you only need 1, not every field that is related which is a common impulse. The reason this will cause a slowdown is because Tableau will be trying to do an inner join on each field in the blend, where its probably really only using the one field anyway.
Yes I have set all the filters to relevant values.
Yes I have done performance recording. I have done performance recording on both tableau server as well as tableau desktop. When the open a dashboard on tableau server for first time, it is taken 6-8 secs and but if I close the dashboard and reopen the same dashboard, it is taking on 4-5 sec. I believe, cache is playing some role here.
I have taken care of blending. I have only linked on the fields which are required and also hidden unwanted fields. But still the performance is not good.
Can you upload the performance recording ? It's important to see what it actually happening that takes 6-8 seconds.
To add further on the topic ,
From 10.5 , the CPU usage and consumption is very high due to the new hyper engine . Unless re-configured ( by re-distributing the worker and nodes) , the refreshes and performance could take a severe beating. in my previous role , This had to be done to improve the performance of the server . If in general ,the server performance then it is worth considering this.
But , in case of specific dashboard performance , Please do follow Chris McClellan advice/instructions , he is an expert in these.
Thanks for your response.
I'm curious to know about the re-distribution work you have done. Can you please share you experience. How did you handle that?
It will be great help.