---
schema_version: "1"
id: e92b575ecf97bb6419d0501fc97da9f6e7fa62d0f7db75af033fa3598adfb945
title: Extract Query Load Balancing
collection: tableau
version: next
locale: en-us
portal_url: https://docs.salesforce.com/tableau/next/en-us/server-linux/load_balancing_eq.md
canonical_url: https://help.tableau.com/v0.0/server-linux/en-us/load_balancing_eq.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 9e88882a54e2390a914e04ce1fe54f09aae2866532ea26af2c7f31e9e0dc1da2
description: Understand extract query load balancing improvements in Tableau Server.
---
[Skip to main content](#main-content)

# Extract Query Load Balancing

In Tableau Server version 2020.2 and later, load balancing for extract-based queries has improved and may result in faster load times for extract-based dashboards. Large deployments that are extract heavy and have a high volume of dashboard loads will probably see the most improvement, particularly if they have Hyper running on standalone nodes. Smaller deployments where Hyper is running on nodes that are shared with other server processes may also see performance improvements.

Hyper logs a server health metric about the amount of resources Hyper is consuming and also takes into account load from other Tableau processes that may be running on the same server node. Based on this information, extract queries will be sent to a node that has available resources to process the query. In addition to evaluating system resources, the load balancer improves the chance that the node you are routed to has the extract already cached. This reduces the number of duplicate extracts across nodes and improves memory and I/O usage.

To use this feature, the Cache Server process must be active. For more information, see [Tableau Server Cache Server](https://help.tableau.com/v0.0/server-linux/en-us/server_process_cache-server.htm). If Cache Server process is not enabled, load balancing will automatically revert to the previous functionality.

This feature is turned on by default. To disable it, use the following tsm commands:

`tsm configuration set -k hyper_standalone.consistent_hashing.enabled -v false`

`tsm configuration set -k hyper_standalone.health.enabled -v false`

Apply the changes using the following tsm command: `tsm pending-changes apply`

For more information, see [tsm configuration set Options](https://help.tableau.com/v0.0/server-linux/en-us/cli_configuration-set_tsm.htm).