15.10 - TASM: Priority Scheduler Columns - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

These columns provide data specific to the Priority Scheduler.

For more information about the ResUsageSps table and columns, see ResUsageSps Table.

Column Name Mode Description Data Type
PSNumRequests count Number of work requests received on this node. FLOAT
PSQWaitTime count Time in centiseconds that work requests waited on an input queue before being serviced.

To get an approximate average QWaitTime per request during this period, divide QWaitTime by NumRequests.

FLOAT
PSServiceTime count Time in centiseconds that work requests required for service.

To get an approximate average ServiceTime per request during this period, divide ServiceTime by NumRequests.

FLOAT