Teradata Virtual Storage (VS): I/O Statistics Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

These columns identify the I/O statistics reported by FSG for each AMP.

Column Name Mode Description Data Type
ConcurrentMax max Maximum number of concurrent I/O requests. FLOAT
ConcurrentReadMax max Maximum number of concurrent read I/O requests. FLOAT
ConcurrentWriteMax max Maximum number of concurrent write I/O requests. FLOAT
ReadCnt count Number of logical device reads. FLOAT
WriteCnt count Number of logical device writes. FLOAT
ReadKB count Number of KB read from the logical device. FLOAT
WriteKB count Number of KB written to the logical device. FLOAT
ReadRespTot count Total of individual read response time in centiseconds. FLOAT
WriteRespTot count Total of individual write response time in centiseconds. FLOAT
ReadRespMax max Maximum of individual read response time in centiseconds. FLOAT
WriteRespMax max Maximum of individual write response time in centiseconds. FLOAT
ReadRespSq count Total of squares of the individual read response time in centiseconds. FLOAT
WriteRespSq count Total of squares of the individual write response time in centiseconds. FLOAT
OutReqTime count Time with outstanding requests (busy time), in centiseconds. FLOAT