DWHPro Insights

Global Teradata System Characteristics Database: Help Us Build It!

By Roland Wenzlofsky ·

Global Teradata System Characteristics Database: Help Us Build It!

Teradata administrators worldwide face similar challenges.

I propose creating a worldwide database containing the characteristics of Teradata systems. This will allow for easy comparison and analysis of performance issues between different systems.

My initial report displays the CPU idle time and the number of disk I/O waits for every hour throughout the day.

To contribute to the database construction, please execute the following SQL statement on your system:

SELECT
EXTRACT(HOUR FROM TheTime) time_of_day,
((sum(CPUIoWait)) / NULLIFZERO(sum(CPUIoWait+CPUUExec+CPUUServ+CPUIdle)))*100 as CPU_WAITING,
((sum(CPUIdle)) / NULLIFZERO(sum(CPUIoWait+CPUUExec+CPUUServ+CPUIdle)) ) *100 as CPU_IDLE
FROM
DBC.ResUsageSpma
WHERE TheDate between DATE-30 AND DATE-1 GROUP BY time_of_day ORDER BY 1;

Runtime and row count depend on logging coverage, retention and workload. A current-day adaptation with a guarded denominator returned 22 hourly rows; it does not validate the original 30-day workload. Confirm TheTime is a TIME-compatible field on the target system.

Teradata Query Performance Tuning: The DWHPro Guide book cover

Get the complete Teradata tuning book, free

Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis

206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.

Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.

About the free book

Typically, the data in the DBC.ResUsageSpma table is regularly purged and saved in a backup table. It is presumed that you have knowledge of the implementation and location of this process on your system.

Please provide details regarding the system type, number of nodes, and AMPs.

This was a historical proposal for a shared collection. Its current operational status is unconfirmed; do not send system information without confirming the recipient, purpose and your organization’s approval. Related: ad***@****ro.com.

This was a historical proposal for a shared collection. Its current operational status is unconfirmed; do not send system information without confirming the recipient, purpose and your organization’s approval.

Kindly inform me of any additional measures that may interest you. I believe that a database of measures would be advantageous for everyone.

Best regards,

DWH Pro

Deciding what to change in your data platform?

Compare optimisation, modernisation and migration against your workload and business requirements.

Explore independent platform assessments

Teradata Query Performance Tuning: The DWHPro Guide book cover

Get the complete Teradata tuning book, free

Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis

206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.

Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.

About the free book

Follow DWHPro in Google to see our articles more often in Search.

2 thoughts on “Global Teradata System Characteristics Database: Help Us Build It!”

  1. I cannot oversee the legal situation regarding the confidentiality of such information. Depending on where you reside and where you work, anything from full disclosure to strict confidentiality is possible.

    I recommend clarifying with your company if such information is allowed to be made public. Any information published shall be done in an anonymized form, i.e. without mentioning the very system or company it came from.

    Treat it like an opinion poll where you are asked about your preferences and your situation, without being named.

    Thank you for the comment.

    Reply

Leave a Comment

Teradata Query Performance Tuning: The DWHPro Guide book cover

Get the complete Teradata tuning book, free

Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis

206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.

Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.

About the free book

Protected by Security by CleanTalk and CleanTalk Anti-Spam