16.20 - Teradata Database Alert Metrics and Properties - Teradata Workload Management

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
These metrics are available for Teradata Database alerts. The associated property names allow you to customize alert actions in the Alert Setup portlet or customize the message in the Monitored Systems portlet.

Metrics for Node and Vproc Alert Types

Metric Description Property Name
AMP CPU Skew (system level) Comparison of CPU use on the busiest AMP to the average AMP on the system ampCpuSkew
AMP CPU Usage (system level) Average percent of CPU usage of all online AMPs in the configuration on the system aveAmpCpuUsage
AMP Disk Usage (system level) Average percent of disk usage of all online AMPs in the configuration on the system aveAmpDiskUsage
Available AWT Total available AMP worker tasks availableAWTCount
CIC Usage Percent of Channel Interface Controller usage for this resource cicUse
CPU Usage Percent of CPU usage that is not idle (includes system CPU and user CPU) cpuUse
Disk I/O Number of disk I/Os diskIO
Disk Out Req Avg Average number of outstanding disk requests for this resource diskOutReqAvg
Host I/O Number of host I/Os hostIO
Message Count Messages waiting on the vproc msgCount
Net A Usage Total BYNET utilization (BYNET receiver usage) netAUse
Net A Usage (system level) Total BYNET utilization (average of the online BYNETs) on the system systemNetAUse
Node CPU Skew (system level) Comparison of CPU use on the busiest node to the average node on the system nodeCpuSkew
Node CPU Usage (system level) Average percent of CPU usage of all online nodes in the configuration on the system aveNodeCpuUsage
Node Disk Usage (system level) Average percent of disk usage of all online nodes in the configuration on the system aveNodeDiskUsage
PE CPU Usage (system level) Average percent of CPU usage of all online PEs in the configuration on the system avePeCpuUsage
Status Status of the node or vproc, where U means the resource is up and D means the resource is down status
Swaps Total number of swap reads and swap writes swaps
Total Sessions Number of sessions logged in to the PE sessLogCount

The following metrics are not available in the dialog box, but can be entered in the message included with the alert by using the property name with the syntax ${alertProperty}. These properties can also be used to customize alert actions in the Alert Setup portlet.

Metric Description Property Name
ID ID of the process procId
Node ID ID of the node nodeId
Vproc Number Number of the vproc vprocNo

Metrics for Database Space Alert Types

Metric Description Property Name
Current Perm % Percentage of the total permanent disk space the database is currently using (Current Perm divided by Max Perm) spaceUsedPct
Current Perm Max % Current Perm Max * Number of Vprocs / Max Perm maxSpaceUsedPct
Current Spool Space % Percentage of total temporary spool space the database is currently using (Current Spool divided by Max Spool) currentSpoolPer
Effective Perm Space % Larger of two values: Percentage of perm space used, accounting for the configured skew limit, on the highest utilized AMP or percentage of Perm space used in the database as a whole. effectivePermSpace
Peak Spool Space % Highest percentage of total temporary spool space the database has used (Peak Spool divided by Max Spool) peakSpoolPer

The following metric is not available in the dialog box, but can be entered in the message included with the alert by using the property name with the syntax ${alertProperty}. These properties can also be used to customize alert actions in the Alert Setup portlet.

Metric Description Property Name
Database Name Name of the database databaseName

Metrics for Session Alert Types

Metric Description Property Name
Account Account from which a query was submitted userAccount
Active Time Amount of time the query has been running activeTime
AMP CPU Current elapsed CPU time, in seconds, used on all AMPs by the associated session for executing requests ampCPUSec
AMP I/O Current number of logical Reads and Writes issued across all AMPs by the associated session ampIO
Blocked Time How long the query has been blocked blockedTime
Connection Time How long the session has been connected timeLoggedOn
CPU delta Total CPU usage time consumed, in seconds, since the last sample deltaCPU
CPU Skew CPU skew during the last sample cpuSkew
Delay Time Amount of time a session has been delayed by utility, system throttle, workload throttle, or workload group throttle rules delayTime
Delta I/O I/O count since the last sample deltaIO
Host ID Host ID or LAN ID associated with the PE that processed the login request for the session hostId
Hot AMP CPU CPU time of the highest CPU utilized AMP during the collection interval hotAmp1CPU
Idle Time How long the query has been idle idleTime
Logon Source Logon source containing the application ID and client ID logonSource
Partition Partition to which the session is connected (SQL, CONSOLE, MONITOR) partName
Request AMP CPU Current elapsed CPU time, in seconds, used on all AMPs by the current request requestAmpCPU
Request AMP I/O Current number of logical Reads and Writes issued across all AMPs by the current request requestAmpIO
Responding Time How long a completed query is taking to send (respond) spooled data back to the user respondingTime
Sessions Per User Number of sessions logged in under this username sessionsForUser
Spool Space Amount of spool space used across all AMPs by this request requestAMPSpool
Utility Session Session from one of the Teradata utilities, indicated by True and False utility

The following metrics are not available in the dialog box, but can be entered in the message included with the alert by using the property name with the syntax ${alertProperty}. These properties can also be used to customize alert actions in the Alert Setup portlet.

Metric Description Property Name
Blocking Session Number 1 Session ID of the first blocking query blk1SessNo
Blocking Session Number 2 Session ID of the second blocking query blk2SessNo
Blocking Session Number 3 Session ID of the third blocking query blk3SessNo
Blocking User Name 1 Name of the user running the first blocking query blk1Username
Blocking User Name 2 Name of the user running the second blocking query blk2Username
Blocking User Name 3 Name of the user running the third blocking query blk3Username
Session Number Number of the session sessionNo
User User of the session userName

Metrics for System Alert Types

Metric Description Property Name
AMP CPU Skew Comparison of CPU use on the busiest AMP to the average AMP ampCpuSkew
AMP CPU Usage Average percent of CPU usage of all online AMPs in the configuration aveAmpCpuUsage
Blocked Sessions Total number of blocked sessions blockedSessions
Net A Usage Total BYNET utilization (average of the online BYNETs) on the system netAUse
Node CPU Skew Comparison of CPU use on the busiest node to the average node nodeCpuSkew
Node CPU Usage Average percent of CPU usage of all online nodes in the configuration aveNodeCpuUsage
Node Disk Usage Average percent of disk usage of all online nodes in the configuration aveNodeDiskUsage
PE CPU Usage Average percent of CPU usage of all online PEs in the configuration avePeCpuUsage
Total Sessions Total number of logged in sessions totalSessions

Metrics for System Health Alert Types

Metric Description Property Name
Health Name of the system health state health

Metrics for Table Space Alert Types

Metric Description Property Name
Current Perm Amount of permanent disk space the DBC.TransientJournal table is currently using totalSize
Skew Percentage of uneven distribution of disk space used for the DBC.TransientJournal table across all AMPs skewPct

Metrics for Canary Queries Alert Types

Metric Description Property Name
Canary Query ID ID of the canary query canaryId
Login Timeout Occurred Timeout for the login, indicated by True or False loginTimeoutOccurred
Query Name Name of the query queryName
Response Time Number of milliseconds it took for the canary query to return a response responseTime