I would like to ask you about the DBC.ResUsageSpma Table and the performance of the Teradata.
We have a Teradata 2800 with 2 Nodes and we are having some performance issues. When I take a look at the DBC.ResUsageSpma the results the attached.
Is something wrong with Node ID 105?.
Thanks in advance.
It does appear that at some point 1-05 was down and VProcs migrated to 1-02. You could filter your ResUsage query based on date/time to see if that state is recent or just historical.
Viewpoint or PM/API can also be used to check current state.