Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 198 199 200 201 202 203 < 204 > 205 206 207 208 209 210 .. 218 >> Next


D - 10

Teradata RDBMS Database Administration Appendix D: Tools for Monitoring Performance

Resource Check Tools

ResUsage Reports

ResUsage data is statistical usage information sampled from Teradata RDBMS resources during a logging period you specify. The ResUsage feature provides:

Tools to set the data sampling period (collection rate) and logging interval.

In conjunction with PM/API, the Teradata Performance Monitor facility allows you to display the collected data. Because the data is updated based on the collect rate, you can view the data in near-real-time. (On UNIX, the Resource Sampling System Monitor (RSSMon) offers similar capabilities.)

A suite of system tables in which the logged data is recorded.

A suite of macros that mine the data to return formatted aggregate reports.

A suite of views you can query to look at the contents of the logs.

Using the Reports

You can use ResUsage reports to:

Measure system and component usage

Establish baseline performance standards

Measure performance degradation and improvements

Identify potential areas of impact

Troubleshoot bottlenecks, parallel inefficiencies, and slowdowns

Assist on-site production scheduling

Plan for and justify expansion

Reporting Capability

For the duration of the logging interval, ResUsage can report the following:

Number of times a particular event, such as a disk read or write, occurred

Amount of time a resource, such as a CPU, was actually in use

Number of active statements by type (DML and DDL)

Number of active statements by individual command (GRANT, INSERT, SELECT, CREATE, and so forth)

Number of statements that ended normally, failed, were aborted, or generated an error

Number of AMP "last done" events and how often the AMP with the highest count was the last one done

Transaction lock activity by type, and such effects on processing as:

Number of process blocks used for transaction locks

Total and maximum counts of requests blocked by locks Number of times a transaction lock was blocked and deadlocked

Teradata RDBMS Database Administration

D - 11 Appendix D: Tools for Monitoring Performance

Resource Check Tools

Number and counts of load and archive utility operations in progress, by command type

Number and sum of Cylinder Read activities, by type, such as cache-full rejections and file system, FSG-denied, and threshold-denied requests

Value of measurable items, such as queue lengths

Sum of multiple samples of a measurable item, such as a queue length

ResUsage can report this data by:

Vproc, if applicable

Single node

All nodes

Node group name (if your installation has node co-existence)

Co-existence nodes are nodes configured in your TPA that differ based on CPU speed, model number, or some other factor. You can identify the node groups any way you want.

After you define the node GroupIDs to the views created by DIPRUM (see Appendix E: "Database Initialization"), you can analyze ResUsage reports at the group level without needing to use hand calculations or separately developed spreadsheets.

Documentation References

Further information is available as follows:

IF you want information on ... THEN see .
what type of data is sampled for what resources "PM/API Dynamic Data" on page D-6 Teradata RDBMS Resource Usage Macros and Tables
the collection period and logging interval and how to set or change them "GET/SET RESOURCE" in the chapter titled "DBW Supervisor Commands" in Teradata RDBMS Database Window Teradata Manager online help UNIX only: "RSS Settings" in the chapter titled "xctl Utility" in Teradata RDBMS Utilities Windows 2000 only: "Screen RSS Command" in the chapter titled "ctl Utility" in Teradata RDBMS Utilities
the current logging status (on or off) for any or all ResUsage log tables "GET/SET LOGTABLE" in the chapter titled "DBW Supervisor Commands" in Teradata RDBMS Database Window

Teradata RDBMS Database Administration D - 11 Appendix D: Tools for Monitoring Performance

Resource Check Tools

IF you want information on ... THEN see .
Using Teradata Performance Monitor Starting the RSSMon utility (UNIX) Teradata Manager User Guide Teradata Manager online help UNIX only: "RSSMon" in Teradata RDBMS Utilities
Contents of the ResUsage tables Running ResUsage macros Examples of ResUsage reports Teradata RDBMS Resource Usage Macros and Tables
Interpreting ResUsage data to improve performance Benefits and costs of collecting ResUsage data Teradata RDBMS Performance Optimization

Teradata RDBMS Database Administration

D - 11 Appendix D: Tools for Monitoring Performance

Teradata Performance Monitor

TDP Transaction Monitor

The Teradata Director Program Transaction Monitor (TDPTMON) routine tracks the elapsed time of requests and responses as they are processed by the TDP.
Previous << 1 .. 198 199 200 201 202 203 < 204 > 205 206 207 208 209 210 .. 218 >> Next