There's more...

Application DBAs need to identify the classification of the workload in which the application would be running. This classification mostly remains for a lifetime unless there are major changes that occur on the application side. The nature of the query is still governed by throttles and exceptions, so even if the high priority workload query does something unexpected to the system, TASM has the ability to kill the query and safeguard other applications on the system.

From the Viewpoint workload portlet, you can also witness the health of your workloads. Workloads who have missed their SLGs will be displayed in red. This can be seen in the following figure:

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.