Sizing | QueryGrid - QueryGrid Manager Sizing - Teradata QueryGrid

QueryGrid™ Installation and User Guide - 3.06
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
lifecycle
latest
Product Category
Analytical Ecosystem
The following is a list of the minimum requirements for QueryGrid Manager to serve 200 data source nodes and monitor up to 5000 QueryGrid queries a day. A single QueryGrid Manager can support up to 8 CPUs and use a maximum of 16GB of memory.
  • 2 CPU cores
  • 2.2GHz
  • 16GB memory
  • 250GB of disk space mounted on /var/opt/teradata/tdqgm

    Do not store /var/opt/teradata/tdqgm on the same partition as root.

Number of QueryGrid Manager Instances

For each Data Center, determine the number of QueryGrid Managers needed. One instance of QueryGrid Manager is installed on a TMS, customer-supplied server, or VM.

The following guidelines are based on the minimum hardware requirements for the TMS, server, or VM.

Requirements Description
TMS, Server, or VM for QueryGrid Manager One or more (separate server for each QueryGrid Manager instance).
Important: Do not install on existing TMS servers hosting Viewpoint, Data Mover, Ecosystem Manager, and so forth, unless those products are uninstalled and the server is re-purposed to be a QueryGrid Manager server.
Minimum number of QueryGrid Manager instances One instance for approximately every 200 QueryGrid-connected nodes:
  • This approximation is based on moderate query volume on minimum supported hardware requirements.
  • Actual required number varies depending on server specifications and query volume.
  • New QueryGrid Managers can be added if the load is high on existing instances to reduce the overall load.
Minimum number of QueryGrid Manager instances for high availability (HA) Two instances:
  • More than two instances can be deployed.
  • Multiple instances can be clustered for high availability and scalability.
  • Each instance in a cluster is fully active and maintains a full copy of the QueryGrid configuration.
Number of QueryGrid Manager instances to keep communication, heartbeats, query metrics, and log data local to a Data Center At least one per Data Center, more if the number of nodes in the Data Center exceed the resource requirements of the single QueryGrid Manager instance.

Server load is displayed by Linux utilities such as uptime and top. The load average should be less than the number of CPU cores. If the load is persistently higher than the number of CPU cores, this is a good indication that another QueryGrid Manager is needed.