Memory: Large Memory Sort Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢
Column Name Mode Description Data Type
FileSorts count Number of sort requests, including the large memory sort requests. FLOAT
FileLargeMemSorts count Number of large memory sort requests executed. Large memory sort uses large buffers (1MB buffers) and up to 1GB of memory. FLOAT
FileLargeMemSortsDenied count Number of large memory sort requests denied. FLOAT