Load testing
This content is part of Tableau Blueprint – a maturity framework allowing you to zoom in and improve how your organisation uses data to drive impact. To begin your journey, take our assessment(Link opens in a new window).
Note: This topic applies to Tableau Server only.
Load testing helps you understand your Tableau Server’s capacity with respect to your unique environment, data, workload and usage profile. Because data, workload and usage will change as new content is authored, new users are onboarded and the use of analytics increases, load testing should be conducted two to four times a year in conjunction with upgrades and server scale-up or scale-out expansions.
Created by Tableau, TabJolt is a point-and-run load- and performance-testing utility specifically designed for Tableau Server. It helps you understand how Tableau Server scales with increasing workloads to inform your capacity needs. TabJolt automates user-specified loads for any duration, while eliminating the need for script development and script maintenance, which is often required with other load-testing solutions. With increasing user loads, Tableau Server scales nearly linearly with load by adding more nodes to the cluster for Windows and Linux.
Load-testing best practices are listed below:
- Load testing should be conducted with TabJolt on an identical test environment with content restored from the production environment. This is not only from a hardware and Tableau Server topology perspective but also in terms of data volume.
- Select representative content from your top-viewed workbooks. Often the cause of scalability and performance issues can be workbooks being not authored with best practices in mind. If a single-user test on your workbooks shows a very slow response time, then you should optimise those workbooks before you begin a load-testing project.
- During testing, increase the workload to 75-85% CPU utilisation and < 2% error rate.
- Start with the default process configuration determined by Tableau Server’s architecture-aware installer and scale up or out as needed when the threshold is met and sustained.
- In most cases, increasing process counts above the defaults does not improve performance, unless enough hardware resources are available.
- It is always good to know the breaking point of the server in terms of how many users/requests and how much data it can handle.
Developing a test plan:
- Choose representative workbooks.
- Model the expected usage.
- Think about peak usage.
- Run for at least ten minutes.
- Include thinking time.
- Stop other work on the server.