1 of 1 people found this helpful
Hi Yogi. Prior to version 10.5, Tableau uses the legacy TDE data engine for extracts. And this has post-processing after the importing of the data in order to materialize calculations / sort / etc. and this always happens after the import regardless if there were any rows imported or not. So this is likely what's happening with your incremental refresh.
If you have the ability to upgrade, then go to 2018.3 as it has many new features, it's the latest and greatest, and the Hyper data engine has replaced the TDE data engine and doesn't have this post processing overhead associated with it.
I would like to upgrade but due to some dependency I can't.
Is there any other way around we can increase incremental refresh faster with 9.0?
I recommend to troubleshoot from both the end, SQL Server and Tableau.
As Jeff said, there is no good scope in Tableau to tune, but in SQL Server try to debug and watch whats happening during that 10min time.
Use Activity monitor in management studio to look the request and proceed from there.
Hope this helps.
As I connected to physical table, I don't think there will be a scope to improve performance in sql server.
I think I have to find a way to upgrade the Tableau server ASAP.
Yogi. The only other way is to up the CPU horsepower.