This is a massive speed lift for us. Perhaps your IT windows admin already has this covered. But if not, read on...
If you have sub-optimal performance, there could be many many contributing factors (i.e. workbook design best practices). But still, there may be a few "easy buttons" out there. The one that we came across (within our on-premise Tableau Server deployment) has to do with an underlying server BIOS setting.
We run Dell physical server hardware. Mind you that each BIOS version seems to have different default settings and options, our BIOS default was DAPC (Dell Active Power Controller), which essentially indicates a variable speed CPU frequency based on demand. So the more demand, the higher the clock speed. This is quite beneficial from an overall datacenter energy footprint and perhaps an electrical engineer out there won an award for this, however it's not so handy for optimal Tableau performance. We recently changed to a system profile of "Performance". For more info about the internals, see here: Dell PowerEdge R730 Owner's Manual
Before the change, the clock speed is usually in the 1Ghz range and it fluctuates based on CPU demand. Here's a screenprint from one of our dev boxes (1.57 GHz).
After the change, the clock speed speed stays at the maximum (with turbo-boost turned on).
So, with today's processors, for many transaction based applications, variable speed is great, it saves power. But for computational intensive platforms (i.e. Tableau), it's not so great.
We wondered what the power delta was, so we went and captured it via Perfmon / a Tableau dashboard. It's not so much. ~ 100 watts.
And now for the rendering impact / extract impact.
RENDERING times - adjusted BIOS setting late on 4/17
- Tableau Server users are giving high fives!!!!
- Decisions are being more swift!!!
- It's getting closer to me being able to grab a well deserved drink!!!
EXTRACT times - adjusted BIOS setting prior to 4/14 run,
- Maximize your investment
- This by no means is a blanket endorsement to go in and adjust your BIOS setting
- Go have a look at your BIOS settings, and share what you find out
- For those wondering what's up with the above motorcycle picture, this is Evel Knievel. if you've never heard of him, go watch some cool videos on Youtube