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:
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.
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 bookTypically, 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.
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
By sending this information, aren’t we violating customer’s right to infrastructure privacy??
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.