Global Teradata System Characteristics Database: Help Us Build It!

admin4

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.

Want more practical data engineering analysis like this?

Join DWHPro Letters and get field-tested notes on Teradata, Snowflake, AI, migrations, performance, and enterprise data work. Early subscribers keep launch access before the paid plan launches.

Get the next issue

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

Get the next issue by email.

SELECT EXTRACT(HOUR FROM TheTime) time_of_day, ((sum(CPUIoWait)) / (sum(CPUIoWait+CPUUExec+CPUUServ+CPUIdle)))*100 as CPU_WAITING, ((sum(CPUIdle)) / (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;

The query will execute in just a few seconds and retrieve 24 records, each representing an hour.

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.

Please send your results to admin@dwhpro.com (plain text or Excel Sheet).

I will collect all results and make them available online (charts & tables). Here is our current collection:

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

Planning or surviving an enterprise data platform migration?

I write regularly about the performance, cost, architecture, and project mistakes that show up in real Teradata, Snowflake, Databricks, and enterprise data work.

Subscribe before the paid plan launches and keep launch access.

Written by Roland Wenzlofsky, founder of DWHPro and author of Teradata Query Performance Tuning. DWHPro has helped data warehouse practitioners for 15+ years.

Subscribe to DWHPro Letters