Suggested Alerts and Thresholds - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - Database Administration

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
tgx1512080410608.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
ujp1472240543947
Product Category
Software
Teradata Vantage

The following table lists key events and the values that constitute either warning or alerts.

Type Event Warning Critical
CPU saturation Average system CPU > x% (x = 95)  
I/O saturation CPU+WIO > x% and WIO > y% (x = 90, y = 20)  
Query blocked Query or Session blocked on a resource for longer than x minutes, and by whom (x = 60)  
Entire system blocked Total number of blocked processes > x   (x = 10)
User exceeding normal usage Number of sessions per user >x (with an exclusion list, and custom code to roll up sessions by user) (x = 4)  
“Hot Node” or “Hot AMP” problem Inter-node or inter-AMP parallelism is less than x% for more than 10 minutes (x=10)  
Disk space Disk Use > x% (vproc) (x=90) (x=95)
Product Join Average BYNET > x% (system) (x=50)  
System restart Restart   SNMP
Node down Node is down   SNMP
Heartbeat query Timeout   SNMP