Developing Performance Monitoring Applications - Resource Information

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

Developing Performance Monitoring Applications - Resource Information

This is the second in a series of articles.

       View the first article.

       View the series index.

Resource information is available in both summary and detail formats. Each type of information is also available at both the physical (Node) and virtual (Vproc) level.

If you want to get a general idea of the health of your Teradata system you should look at the summary information. These functions retrieve only a small amount of data and are therefore ideal for frequent use, or for storing historical trends.

Physical Summary (Node) Information

To view summary information based on resource usage reported by the Nodes in your Teradata system you should use the GetNodeSummary method.

This method will return a NodeSummary object that contains properties describing the average, most heavily used, and least heavily used nodes in your system. It also contains Bynet usage information, the current resource monitoring and logging rates, and the Teradata release and version information.

To retrieve Node summary information:

In VB:    Dim NodeSum As NodeSummary

              Set NodeSum = gMon.GetNodeSummary

In C#:   NodeSummary NodeSum;

             NodeSum = gMon.GetNodeSummary();

In C++:  _NodeSummary *pNodeSum;

              HRESULT hr = pMon->GetNodeSummary(&pNodeSum);

You may then reference all the available node summary information as properties of this NodeSummary object.

Virtual Summary (Vproc) Information

To view summary information based on resource usage reported by the Vprocs (AMPs and PEs) in your Teradata system you should use the GetVprocSummary method.

This method will return a VprocSummary object that contains properties describing the average, most heavily used, and least heavily used Amps and PEs in your system. It also contains the total Session count, the current resource monitoring and logging rates, and the Teradata release and version information.

To retrieve Vproc summary data:

In VB:     Dim VprocSum As VprocSummary

               Set VprocSum = gMon.GetVprocSummary

In C#:    VprocSummary VprocSum;

              VprocSum = gMon.GetVprocSummary();

In C++:  _VprocSummary *pVprocSum;

              HRESULT hr = pMon->GetVprocSummary(&pVprocSum);

You may then reference all the available vproc summary information as properties of this VprocSummary object.

Resource Detail Information

If you need to examine the resource details you can drill down to the detailed information for each Node or Vproc in the system by calling the resource detail methods.

Physical Resource Details (Nodes)

To view detail information for each node in your Teradata system you should use the GetNodeDetail method.

This method will return a Nodes collection. Each Node object in the collection contains properties describing the resource usage of that node during the most recent collection interval.

To retrieve node detail information:

In VB:    Dim Nodes As Nodes

             Set Nodes = gMon.GetNodeDetail


In C#:   Nodes mNodes;

              mNodes = gMon.GetNodeDetail();


In C++:  _Nodes *pNodes;

              HRESULT hr = pMon->GetNodeDetail(&pNodes);

You may then iterate through the Nodes collection to examine the performance values for each individual Node.

Virtual Resource Details (Vprocs)

To view detail information for each AMP and PE in your Teradata system you should use the GetVprocDetail method.

This method will return an AMPs collection and a PEs collection. Each AMP object in the AMPs collection contains properties describing the resource usage of that AMP during the most recent collection interval. Each PE object in the PEs collection contains properties describing the resource usage of that PE during the most recent collection interval.

To retrieve vproc detail information:

In VB:    Dim Amps As AMPs

              Dim PEs As PEs

              Set Amps = gMon.GetVprocDetail(PEs)

In C#:    AMPs Amps;

              PEs Pes;

              Amps = gMon.GetVprocDetail(Pes);

In C++:  _AMPs *pAmps;

              _PEs *pPEs = NULL;

             HRESULT hr = pMon->GetVprocDetail(&pPEs, &pAmps);

Note: In C++, when calling the GetVprocDetail method, you must initialize the PEs collection to NULL before calling the function. Failure to do so will cause the method to fail in Microsoft's setup code.

You may then iterate through the AMPs and PEs collections to examine the performance values for each individual AMP or PE.

Please refer to the Reference Guide for detailed information on the Object Model.

1 REPLY

Re: Developing Performance Monitoring Applications - Resource Information

You are off to a great start, Mike. I am the owner of an Application Monitoring company called Techout. We are headquartered in Red Bank, NJ. Perhaps in the future we can network.

Sincerely,
Techout