Moved to Server Admin. They should be able to help. FYI: Custom SQL will always be slow since Tableau is wrapping your query with its own, making yours a subquery. Your best option is to move the SQL over to the DB side.
1 of 1 people found this helpful
You should create a Performance Recordnig to know why your workbook is slow on Tableau Server: Create a Performance Recording
Adding a process will not help you.
are there a lot of calculations? are you pulling in a lot of columns to the viz? What does the viz look like, can you supply a snapshot? We encounter the same problem on crosstab type reports.
I know that Custom SQL will slow performance down, but I thought it was true on Live connection mode. If I connect my data source on Extract mode, will Custom SQL be a problem? I think that tableau has extract database data into tde file from which it execute queries much more efficiently. In fact, I'm still not sure on this issue. Hope you could give me some information.
Here is a snapshot of my dashboard. There are nearly 50 thousands marks in total. The two pareto graphs are most time consuming with a lot of table calculations.
I have created a performance recorder comparing its load performance in desktop and server http://community.tableau.com/thread/192870. What always puzzles me is that this workbook takes a lot of time on queries after publishing onto tableau server. I connect to my data-source with Custom SQL + Extract mode. Normally, my data has been put into a tde file and updated to tableau server with this twbx file. Why these queries are so slow?can't understand...Hope to know what you think.
I have created a performance recorder for this workbook on tableau desktop and server respectively. see performance of a same workbook on desktop and server. What always puzzles me is that this workbook takes a lot of time on queries after publishing onto tableau server. I connect to my data-source with Custom SQL + Extract mode. Normally, my data has been put into a tde file and updated to tableau server with this twbx file. Why these queries are so slow?Can't understand why...Hope to know what you think.
Hope to hear your voice~~
Nice dashboard !
You got four charts in your dashboard . Do this:
1.create one twbx with a single chart
2.run it and record its performance on sever
3.repeat the above for each of the 4 charts
The idea is to isolate the culprit in performance drain. Then try to fix it.
I suspect that the box and whisker plot is the one with lots of sorting.
The Pareto needs sorting too. Sorting is a perf killer. Run it to figure it
On Monday, November 9, 2015, CHEN Junxian <
Sorry. It got six charts! Box plots and paretos got a lot of marks.
ps. I see my native province on the dashboard. So hilarious !
Try this: add ?:render=false at the end of that view's URL. e.g. http://localhost/views/Supplies/MyView?:render=false and let us know if it helps.
Adding ?:render=false turns of Tableau's default "client-side rendering" and shifts the rendering work to server instead. Sometimes this helps performance of complex workbooks. For more info: http://onlinehelp.tableau.com/current/server/en-us/help.htm#browser_rendering.htm
I had already tried rendering work to server side, that didn't help much. I think that's probably because I've put enough marks in the dashboard to pass the mark threshold for tableau to render work to the server side itself.
Thanks for your advice!
7 cores and 215 GB of RAM is a little bit out of the ordinary for a physical machine, which leads me to believe you may be on a VM.
If that is the case, have you investigated storage? It's not uncommon for the VM admins to allocate "low end" storage to Tableau since in their mind it's "only a reporting tool". The admins don't understand that we are a robust product that needs the same levels of throughput (and low latency) as an RDBMS.
If you use perfmon and watch the Logical Disk | Disk Queue Length and Average Disk Sec/Transfer counters for the volume Tableau Server is running on, what sort of values do you see? Less than 2 and under ~20-30 ms, hopefully.
Another test you should try is to install Tableau Desktop on this machine and see if the dashboard is "slow" there, too. I suspect it WILL be slower than on your development machine. If it is, then at least you know you're dealing with a HW issue.
You're right, my tableau server is on a VM with two other VMs sharing a single physical machine.
Storage is enough. I have disk C: 13.4G(left)/36G E: 201G/343G and my tableau server consumes 126Gb of hard disk.
About counters, I have much lower values than you've provided: ~10-25ms for disk queue length and 0.001-0.010 for average disk sec/transfer. You can see below:line red is average disk sec/transfer with 10x proportion and the other line is disk queue length with 10x proportion.
Russell, could you please tell what that means for my server and what I could do next to improve workbook loading performance on server? Thank you very much!