---
schema_version: "1"
id: 1ab39211fb5b2e3a371bbea747d71a6d00122f21991fe0c20d6cb01560a7fc6a
title: Extract Query Load Balancing
collection: tableau
version: current
locale: en-us
portal_url: https://docs.salesforce.com/tableau/current/en-us/server-linux/load_balancing_eq.md
canonical_url: https://help.tableau.com/current/server-linux/en-us/load_balancing_eq.htm
source_site: help.tableau.com
content_type: documentation
content_hash: a50309c1421ccf1a2d4cb4c8361d0b92c6a2db3786ab3c028e6166f8b2513fed
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/current/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/current/server-linux/en-us/cli_configuration-set_tsm.htm).