Raising Intelligence - Viewpoint System Health Configuration

Blog
The best minds from Teradata, our partners, and customers blog about whatever takes their fancy.
Teradata Employee

As the Product Manager for Viewpoint, I have the distinct pleasure of discussing, presenting, and demonstrating the extensive feature content to account teams, partners, and customers. My thanks goes out to the Viewpoint Engineering team in providing lots for me to talk about ... And learn. So this is the start of a series of blogs regarding cool features and tidbits I've found and continue to discover within Viewpoint.

For those of you already enjoying Viewpoint, maybe these tidbits provide new insight you were not aware of.  For those of you not yet benefiting from Viewpoint, hopefully these cool feature discussions will increase your excitement and desire to get it.  <shameless plug>

Today's discovery is in regards to Viewpoint's System Health portlet and its configuration capabilities.

The "System Health" portlet comes as part of the Teradata Self Service Portlets bundle with the Viewpoint appliance. System Health provides summary and detail views of multiple Teradata systems' performance based on key performance indicators (KPIs) with customer configurable thresholds. It is a key portlet for DBA monitoring as well as Teradata users, the Self Service aspect of Viewpoint. The System Health summary looks like:

 

And the detail view with metric and threshold displays:

 

Within System Health preferences, one can customize the Teradata Systems to monitor, what icon style to use (I personally like the leaves regardless of what ToddP says), and the interval trend line (60 min here) for the detailed view. Cool stuff but not the configuration aspects I want to discuss here.

I'm often asked where the custom thresholds get configured. The answer is in the Admin menu under Configuration by choosing System Health. That view, when running Viewpoint 13.0.1, would look something like this:

 

So for each KPI, you can customize the Degraded and Critical thresholds to what levels fit your Teradata environment. One can also disable a threshold if they don't need that information for whatever reason.

The interesting tidbit is the addition of the "View Only" option (with Viewpoint 13.0 in Nov-2008). The use case for this addition was a customer often running at 98-99% CPU utilization. Initially they set the CPU thresholds to their maximum settings (Degraded 98% and Critical 99%) but the System Health summary view was too often reporting degraded and critical status and unnecessarily alarming the end users.  In an effort to calm the masses, the KPI was disabled but the DBAs soon realized they still wanted the CPU detailed information just without that KPI participation in the summary status calculation ... and thus "View Only" was created to keep everyone happy.

As documented in the Viewpoint online help for the "View Only" option: The metric is visible in the System Health portlet but the threshold values entered will not be used to determine the status of the system.

If a KPI is set to "View Only", the System Health detailed view will shade that KPI metric with a gray mesh highlight as shown with the "System" and "Wait IO" CPU metrics in the System Health detail view above. This provides easy recognition of KPIs not participating in the summary level calculation.

Hope this was helpful and thanks for listening!

"Here endeth the lesson" - Sean Connery as Malone in The Untouchables.

 

 

4 Comments
Enthusiast
how can i get system health portlets ?
Enthusiast
Hi

What are the differences between Teradata Performance Monitor and viewpoint?

What is the use of viewpoint could you please explanation

Thanks
Ram
Teradata Employee
As mentioned in the Viewpoint forum. The System Health portlet comes bundled with the Teradata Self Service Portlets as part of the Viewpoint Appliance. Very likely, you will also get the Teradata Management Portlets with Viewpoint as well.

The Teradata Management Portlets represent replacement of Teradata Manager and that includes Performance Monitor (PMON). Viewpoint is the new user interface for these types of operations. Note that Teradata Manager and PMON 13.0 versions are the last released versions of these products.
Fan
Hi Gary,

Thanks for your post :) It's really help me. AMP CPU SKEW and AMP IO SKEW is useful but sometimes it drive wrong information if TD only process small amount of records and it can make system health status into CRITICAL or DEGRADED.
Luckily we can convert it into View Only or Disabled so it can be excluded from System Health calculation.

Thanks,
Sandy