Developing Performance Monitoring Applications - Built-in displays

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 - Built-in displays

This is the fifth in a series of articles.

       View the first article.

       View the series index.

This article describes dialogs, such as SQL/Explain, that are built into the Monitor Object for your immediate use. No coding is required. Simply call one of the 'Show' methods and the information will be retreived and displayed in a simple to read format.

The Cpu and Disk Skew dialog

Use the ShowSkew method of the Session object to display the following dialog:

This dialog provides an indication of how good the parallelism is for the work performed on behalf of this session. It displays the number of AMPs that were involved during the most recent data collection interval, and shows the usage on the  3 most heavily used, and 3 least heavily used, AMPs.

You may also use the SQL button on this dialog to display the SQL text of the current query together with its associated Explain plan.

The SQL and Explain Text dialog

Use the ShowSQL method of the Session object to display the following dialog:

This dialog displays the SQL that is currently being executed by the session, together with the Explain plan that is being executed.

For each step in the plan we display the estimated and/or actual cpu time used and the number of I/Os performed for that step.

Once displayed, the user may press the Refresh button on this dialog to refresh the displayed information.

They may also use the SaveAs button to save the information to a file for future use.

The Query Bands dialog

Use the ShowQueryBands method of the Session object to display the following dialog:

This dialog displays all Queryband values that have been defined for either the current session or for the Transaction that is currently executing.

The Password Expired dialog

This dialog will be displayed automatically if the password used in the Connect method has expired. 

No method exists to manually display this dialog.

 

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

Tags (2)
1 REPLY
Enthusiast

Re: Developing Performance Monitoring Applications - Built-in displays

Hi,
I have a doubt over this monitoring sessions. Can you please try to answer my question asked here.

http://forums.teradata.com/forum/extensibility/monitorsqlcurrentstep-on-result-set-of-monitorsession#comment-12762