3 of 3 people found this helpful
What is the server processor that we need to watch closely to ensure cross-database joins can scale?
VizQLServer, Data Server (for published datasources using x-db joins), and Backgrounder (for refreshes of extracted x-db joins and rendering of Subscriptions that use them)
Are there any controls for server admin to constraint the cross-database joins? For example, extract timeout is good for admin to control extract run-time. I have not seen any controls available for cross-database joins
Not that I'm aware, no--they're constrained in the same fashion that normal connections are constrained. Who is allowed to publish, extract refresh timeouts, etc.
Any tips, tricks or workaround that this community can come up if v10 has no server admin controls at all for cross-database joins?
I've built a published datasource for myself that shows connection-level details for all content on Server. So far I've just grabbed a count of how many items are actually using x-db joins (186 workbooks of 6k total). I intend to analyze whether they're being extracted and refreshed on a schedule. I might try and blend (or join, ha!) with some other performance data we collect to see how slow the live connections run. Might try and set up a VizAlert for anyone who publishes a new x-db join connection that informs them "with great power comes great responsibility".
Silly question - can server admin turn the cross-database joins off? I do not think that I will turn it off but what-if things out of control?
Not in a supported way that I am aware of. However, searching through workgroup.yml for "DataIntegration" yields interesting results. Clearly, tweaking those settings is an "at your own risk" endeavor that I wouldn't recommend without Tableau Support ok-ing it.
For what it's worth, we actually saw a drop in CPU utilization when we upgraded to 10.0 from 9.3. I can't say that it will be the same for every environment, but it was enough to give us some breathing room and made me feel more comfortable about the new features. But it's something I do intend to keep an eye on.
Now that Tableau 10 been out for couple of months - do you still feel that you need any of configuration you were looking for?