Great point Alex. The sessions at the conference were very useful for Server tuning, but once you're back at the desk in the office, it's still something of a black box trying to work out what's going on. This request sounds like something that Tableau themselves could provide in the medium term.
This may not be ready for primetime, but I know you two can figure this out. See attached.
User perf mon to watch private bytes on the key Tableau Server processes.
Set reference lines to see where you are pushing into a 'warning track' (2GB per process limit)
Output to CSV for convenience. Output to SQL for live monitoring!
Let me know what you think.
Always test with Desktop on the Tableau Server machine to eliminate the network.
Check desktop logs for queries, ask your DBA to optimize.
Thanks for the workbook, although I'm not sure how to interpret "private bytes". Maybe that's described in the attachment document, but that document is unreadable - have tried two different machines.
Could the perfmon_to_csv.docx file be corrupted?
A good discussion on private bytes:
I used to have a good link to Mark Russinovich's blog on memory, but for some reason those blogs are only showing me comments these days, the original content seems to be unavailable at the moment.