fbpx

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 the own system with others, as this helps analyze performance issues, etc.

I am starting with a simple report, which only shows, for each hour of the day,  the CPU Idle time and Disk IO Waits.

If you would like to help us in building such a database, find below is the SQL statement which has to be executed on your systems:

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 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 as well, which other measures would be interesting from your point of view. I imagine that such a database of measures can be helpful for each of us.

Thanks and Best Regards,

DWH Pro

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"62516":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"62516":{"val":"var(--tcb-skin-color-0)"}},"gradients":[]},"original":{"colors":{"62516":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b4fbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"b4fbe":{"val":"rgb(241, 99, 52)"}},"gradients":[]},"original":{"colors":{"b4fbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Previous Article
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b4fbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"b4fbe":{"val":"rgb(241, 99, 52)"}},"gradients":[]},"original":{"colors":{"b4fbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Next Article
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"62516":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"62516":{"val":"rgb(255, 0, 0)"}},"gradients":[]}}]}__CONFIG_colors_palette__
GET OUR TERADATA BOOK

Roland Wenzlofsky

Roland Wenzlofsky is an experienced freelance Teradata Consultant & Performance Trainer. Born in Austria's capital Vienna, he is building and tuning some of the largest Teradata Data Warehouses in the European financial and telecommunication sectors for more than 20 years. He has played all the roles of developer, designer, business analyst, and project manager. Therefore, he knows like no other the problems and obstacles that make many data warehouse projects fail and all the tricks and tips that will help you succeed.

  • 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.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    You might also like

    >