1 of 1 people found this helpful
Long time no see. Hope all is well.
We've had quite a few growing pains with performance and data server ourselves, so I can relate.
First, this was not your main question but when you connect to the data extract on the server you can then right-click on it and "Create local copy" which will bring those calcs back into your local workbook.
Performance wise we have been trying out a mix of SQL Server vs. TDE options. Each case seems to perform differently either due to dashboard design inefficiencies or SQL Server indexing issues. For the most part we have simply stayed with TDEs with nightly SQL Server refreshes.
For the very large workbooks with extracts (> 300Mb) our performance has been horrible -- 90 sec load times. The guy's users are happy because the Tableau workbook replaced a 3-week long, multi-person data processing effort. So 90 seconds is a godsend for them. However, even with that workbook, there are number of efficiencies we're trying to gain by minimizing the use of "Show sheets as tabs" and switching directly to SQL Server where it makes sense.
Small workbooks connected to large server-based data seems to perform better. We have a couple of large extracts (850Mb+) that people are hitting directly and the response times are generally 12-18 seconds. Still not what I would like to see performance-wise. But we are planning major upgrades to our hardware this Fall which will gives more room to adjust the servers, workers and possibly upgrade our CPU licenses.
Hope this helps in some small way.
Hey there! Thanks for piping in.
Indeed, I know about the "create local copy" (and it has helped!) but there are still some fields that get lost when you swap sources.
I also think that my client is still using an early version of server is compounding my difficulties, but I'm ditching the published data source approach for now.
Hope to see you again in the not-too-distant future.
I figured you already knew about that but figured I throw it out there anyway
If I come across any new data server performance options I'll make sure to send 'em your way.