Teradata Viewpoint 13.02 released

Viewpoint
Teradata Viewpoint is Teradata's strategic and innovative SOV (single operational view) for Teradata DB, Aster, and HDP Hadoop systems management and monitoring that enables Teradata's Unified Data Architecture (UDA).
Teradata Employee

Teradata Viewpoint 13.02 released

Teradata is very pleased to announce the official release of Teradata Viewpoint 13.02 effective January 8th, 2010!

Here are some details regarding this very exciting release. This is the first release of Teradata Active System Management (TASM) portlets, specifically the Workload Health and Workload Monitor portlets. These portlets provide TASM management, monitoring, and reporting functionality that was previously only offered through a TASM screen in Teradata Manager. See below for more information on these new TASM portlets.

The Viewpoint 13.02 release also includes patch integration for the Viewpoint foundation software, Teradata Self Service Portlets, and Teradata Management Portlets. So even if you aren't using TASM, upgrading to Viewpoint 13.02 is recommended to ensure you are at the latest patch levels for your Viewpoint implementation. Corrected items included in this release (some of which were also in the last patch release for 13.0.1):

  • Corrected addition of a user to a role when the user name is all numbers
  • User names with an uppercase letter in middle can now view shared portlets
  • Corrected Filtered Queries portlet SQL and Explain tabs display when Viewpoint server is set to the UK time zone
  • A few naughty balloon behaviors

On to the new portlets ...

Workload Health

Workload Health is a Viewpoint portlet that reports on the health of TASM workloads via key indicators. It offers filter and sort menus allowing customization of the information being displayed. For instance, you can filter on enforcement priority, service level goal (SLG) states, or for workloads that are disabled or inactive. The summary view of workload health will look something like this:

Drilling down into a displayed workload provides an additional level of detail for that chosen workload. The detailed view displays multiple sparklines graphing various metrics against this workload. It includes skylines for easy comparison of actuals to weekly averages. The choice of sparklines and number of weeks in the average are configurable through preferences. Here's a sample of the detailed view:

Workload Monitor

Workload Monitor is the most sophisticated Viewpoint portlet to date and provides a visualization of TASM work flow through a Teradata system. It provides an intuitive view of the different stages of TASM feature management from filters, throttles, to workload definitions (WDs), service level goals (SLGs), as well as exceptions and exception abort or reclassification actions. It also shows the query counts in and out of the system, all of this viewable for several different sampling periods. Further it offers a state matrix icon that indicates what state the system is in whether it is the base state, an operating period (i.e. nightly batch), or some unplanned event state (i.e. resource depletion). The top level view of workload monitor looks like this.

Pretty sweet is it not? I won't go through all the information being displayed here but hopefully it makes sense that garbage can numbers would represent queries being rejected or aborted, the 190 number indicating that 190 queries have been reclassified to another workload due to an exception, and that 104K queries came into the system and 88.6K went out ... all of this over the last 60 minutes. One can drill down on each featured item in the workload monitor view. So if I wanted to see more information on the Users-Short WD, clicking on it would provide me the details for this specific workload. Note the additional options for a real time "Snapshot" view and daily trending.

Or clicking on the workload summary completed queries gives this type of detail. Note at any time, one can choose a different sampling period as shown here.

This is just a small view into what the workload monitor provides. If you would like more details, check out the Teradata Viewpoint 13.02 user manual located on the Teradata Information Products website.

And this is only the start of what is planned for TASM portlets!