Teradata Administrators all over the world are fighting with the same kind of problems.
To help each other, I would like to create a global database containing Teradata systems’ characteristics worldwide, allowing each of us to compare our system with others. This helps analyze performance issues, etc.
I am starting with a simple report, which only shows the CPU Idle time and Disk IO Waits for each hour of the day.
If you would like to help us in building such a database, find below is the SQL statement that has to be executed on your systems:
The query should run within a couple of seconds and will return 24 records (one record per hour).
One hint: Usually, the content of the table DBC.ResUsageSpma is removed regularly and stored in a backup table. I assume you know best how this is implemented on your system and where to find it.
If possible, please add information about the kind of system, number of nodes, and AMPs.
Please send your results to [email protected] (plain text or Excel Sheet).
I will collect all results and make them available online (charts & tables). Here is our current collection:
Please let me know which other measures would be interesting from your point of view. I imagine such a database of measures can be helpful for each of us.
Thanks and Best Regards,