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, optimizing SQLs can be a daunting task.
Monitoring not only involves optimization techniques on the query level, but also on the system level. Like queries, there are some other system parameters that we need to keep track of:
- Nodes utilization
- AMP utilization...