So you have Viewpoint installed and you are logged in for the first time, a blank Viewpoint pane stares back at you ... Now what?
This article discusses some of the commonly used portlets, portlet settings/permissions, and suggested dashboards for various users in a Teradata environment. It is worth noting that there is no single blueprint for Viewpoint that works for everyone, so the focus of this article will be on the Viewpoint usage commonalities considering a Business User, Power User, and DBA and covering the Teradata Self Service, Teradata Management, and TASM Portlets.
Before getting too deep into this article, let's first discuss some of the aspects of Viewpoint that need to be considered.
An important theme of Viewpoint is the self-service aspect, providing the Teradata community more information allowing them to make better decisions about their day. The Teradata Self Service Portlets that are included with the Viewpoint appliance are all good candidates for a business user, and in particular, one that submits ad-hoc queries. A common starting dashboard for this type of user would include the System Health, Canary Response Times, and one of the session/query monitoring portlets, either MyQueries or Query Monitor. System Health even at the summary level gives end-users an idea of how system resources are being utilized based on key performance indicators. This may allow an end-user to understand better why queries may be taking a bit longer to run knowing the system is in a busy state. Regarding permissions, a few customers feel that the summary view of System Health is sufficient for these users and set the permissions accordingly in Roles Manager, shown below for the "clair" system.
Canary Response Times can be used as not only a system performance indicator but can also be guidance to how a certain type of query may perform. For these users, it is imperative to provide a method for tracking the progress of submitted queries. The remaining question to consider is whether these users should see all the queries on the system or just their own. Initially, the thought was that they would most likely be restricted to only seeing their own and therefore MyQueries would be the portlet of choice. One differentiating advantage of MyQueries is the fact that one can see all their queries submitted across multiple Teradata systems in one view. The possibly surprising, more common model however is providing these users with the Query Monitor portlet so they can see, not only their own queries, but all queries on a particular Teradata system. Allowing access to both may be the best approach.
Having information on system queries provides the business users more information about the load of the system and in particular, the status of their own queries. For instance, maybe their query is blocked by another query. Prior to having this visibility, a common business user action was to resubmit the query because "it's usually done by now". If sharing Query Monitor, one should first review the available permissions around this portlet to determine if all aspects of seeing and taking actions on queries should be shared. For example, there may be confidential information in the SQL that shouldn't be shared with everyone. If so, this can be disabled within the Roles Manager for Query Monitor by turning off the "View SQL" portlet option. So this first suggested dashboard would look something like this:
SQL Scratchpad is another important portlet for business users allowing query submittal directly from a Viewpoint portlet. This portlet was covered in a recent blog describing SQL Scratchpad Query Management. Since SQL Scratchpad really has three distinct panes, query submission, query results, and an object browser, it warrants a page to itself and run in a maximized view. SQL Scratchpad offers a management facility similar to query portlets thus allowing both query submittal and management from this single view. One can even monitor the submitted query progress through the Explain plan if so desired. A sample SQL Scratchpad dashboard is below.
Other portlets that may warrant consideration for the business user community would be Viewpoint Calendar and External Content. Calendar provides another means of communication beyond email notification for Teradata events. For instance, communicating a planned maintenance window. Also if there are other web applications desired for linkage in Viewpoint for easier access by the business users, one should check into usage of the External Content portlet.
The Power User will have business user dashboards like the ones above but will also likely need a deeper level of sophistication requiring additional portlets. First, regardless of whether they have MyQueries or not, power users will want Query Monitor. So what else might they need? Power users may want to view metrics usage on systems, so having a dashboard with Capacity Heatmap, Metrics Graph or Metrics Analysis would make sense.
Power users may also want to monitor TASM (Teradata Active System Management) queries through the system and therefore would have a Workload Monitor view. This provides another level of query management specific to TASM and above what the query portlets provide. Workload Monitor is one of the more sophisticated portlets available and therefore could be considered for having a dedicated dashboard. Check out the Teradata Viewpoint 13.02 released article for more information on the new TASM portlets, Workload Monitor and Workload Health.
There really aren't any portlets in the portlet bundles being discussed here that a DBA wouldn't want to have access to. It now just becomes more of a preference as to which ones they include in what dashboards. There are some considerations, certainly, for instance if all the TASM portlets are needed or not due to customer choices of implementation and platform, but overall these decisions will be answered based on DBA preference. There are some seemingly logically related portlets. For instance, having a view of System Health, Canary Response Times, and Query Monitor on a single DBA operations page ... or possibly a summary page that contains Productivity and Todays Statistics.
Therefore, a more interesting discussion may be about how different views of a single portlet may be used to address very different DBA management and monitoring tasks. As discussed in the Teradata Viewpoint 13.03 released article, Query Monitor can be tailored for very different purposes. It wouldn't be uncommon for a DBA to have multiple instances of this portlet in different dashboards. For instance, one monitoring all sessions by session identifiers, another tracking by user or account string, and a third for tracking those top suspicious queries with thresholds set in preferences. Here are samples of a dashboard with different views of Query Monitor, one by session and the other by user:
The same idea can be applied to System Health. Maybe a DBA who has multiple systems to monitor wants a summary view of all, but at the same time wants a view into the detailed thresholds of the production system. Two instances of System Health would provide this:
Similarly, Todays Statistics has three different metric views (System, Performance, Query) that can be chosen in Preferences that could constitute three of these instances, even on the same dashboard page. Node Resources can provide node, vproc, amp, pe views that can provide different information:
So DBAs will have to not only decide which portlets they really need, and in which combinations but will also need to consider the different visualizations a single portlet can provide. Consider the amount of customization a portlet provides (different report columns) and the flexibility in options is vast, with no one blueprint for everyone. As a DBA, one will want to really understand the capabilities of each portlet. On-line help should assist greatly here. Think out of the box here.
So to summarize what has been covered in this article, here is a list of dashboards with possible starting portlet configurations for a Business User and Power User. The DBA is going to be more preference and specific need around the site concerns and activities.
Business User - Dashboard #1:
Business User - Dashboard #2:
Business User - Dashboard #3:
Power User - Dashboard #4:
Power User - Dashboard #5:
If you would like to offer your ideas on portlets and dashboards, please contribute at this Viewpoint Forum Topic