Introduction

There are many ways to monitor the performance of your work. Teradata has tools like viewpoint, where individual users can log on and check how their queries are executing on the system and how it is affecting the other workloads on the system. It empowers individual users to track their work, based on which they can take informed decisions about their queries. Inefficient requests can be killed or performance can be improve.

There are some terms that a user must understand when monitoring queries and workloads.

A query should be the perfect mix of CPU, I/O, and runtime. Finding that perfect mix is a critical task and takes a lot of effort sometimes. With today's growing query complexity and various different analysis needs, ...

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.