TDViewpoint

Teradata Viewpoint is a web‑based monitoring and management portal provided by Teradata.
It gives DBAs, system administrators, workload managers, and support teams a single, centralized view of the Teradata system’s health, performance, and activity.

Think of Viewpoint as the “control cockpit” of a Teradata system.

It does not store data itself; instead, it pulls metadata and runtime statistics from Teradata system tables, logs, and monitoring services (like DBQL and ResUsage).

---

What Can Teradata Viewpoint Be Used For?

1. System Monitoring (Real‑Time Visibility)

Viewpoint is heavily used to monitor current system activity.

You can:

• See active sessions and running queries
• Monitor CPU, memory, AMP usage, and I/O
• Track node and AMP health
• Detect bottlenecks before users complain

Common use case

A DBA opens Viewpoint to see why queries are slowing down during peak hours.

---

2. Workload Management (TASM Integration)

Viewpoint is the primary UI for Teradata Active System Management (TASM).

You can:

• Monitor workloads by priority and type
• See which queries are in:
  • Delay
  • Throttle
  • Execution
• Validate whether workload rules are working as expected

Example

• Business‑critical queries run fast
• Ad‑hoc queries are automatically deprioritized

This is critical for SLA compliance.

---

3. Query Monitoring and Troubleshooting

Viewpoint lets you drill down into query behavior.

You can:

• Identify long‑running or blocked queries
• See query wait states
• Inspect query plans and resource usage
• Cancel runaway queries safely

Typical DBA questions Viewpoint answers

• Who is running the query?
• How long has it been running?
• What resources is it consuming?
• Is it blocking others?

---

4. Historical Analysis & Capacity Planning

By using historical data collected from:

• DBQL
• ResUsage
• System logs

Viewpoint allows you to:

• Analyze trends (CPU growth, query counts, spool usage)
• Predict future capacity needs
• Support hardware scaling decisions

Example

“CPU usage has grown 15% every quarter — we need to plan for expansion.”

---

5. Alerting and Proactive Issue Detection

Viewpoint supports alerts and thresholds.

You can configure alerts for:

• CPU > X%
• Disk space reaching limits
• Node failures
• Excessive query run times

Alerts can be sent via:

• Email
• SNMP
• Dashboard notifications

Benefit
Problems are detected before they impact business users.

---

6. Security and Auditing Visibility

While Viewpoint is not a security tool itself, it supports security monitoring by showing:

• Logged‑in users
• Session sources (IP, client tools)
• Failed login attempts
• Query access patterns

Useful for:

• Audits
• Investigating suspicious activity
• Compliance reviews

---

7. Single Pane of Glass for Administrators

Viewpoint consolidates information that would otherwise require:

• SQL queries
• Manual log checks
• Multiple tools

Key dashboards include:

• System Health
• Workload Health
• Query Monitor
• Resource Trends

This improves operational efficiency.

---

Who Typically Uses Teradata Viewpoint?

Role	How They Use Viewpoint
DBA	Monitoring, tuning, query control
System Admin	Hardware health and capacity
Performance Engineer	Workload analysis and optimization
Teradata Support	Remote diagnostics
Operations	Daily system checks

---

What Viewpoint Is Not Used For

It’s important to clarify limits:

❌ Not for writing SQL
❌ Not for data visualization or analytics
❌ Not a replacement for BI tools
❌ Not meant for application users

---

Simple Summary

Teradata Viewpoint is used for:

✅ Monitoring system health
✅ Managing workloads
✅ Troubleshooting performance issues
✅ Analyzing historical trends
✅ Proactive alerting
✅ Centralized system visibility