DBC.ResUsageSpma - AMPs per Node

Database
SPB
Enthusiast

DBC.ResUsageSpma - AMPs per Node

Hi,

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.

Tags (3)
2 REPLIES
Teradata Employee

Re: DBC.ResUsageSpma - AMPs per Node

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.

SPB
Enthusiast

Re: DBC.ResUsageSpma - AMPs per Node

Yes, that was the problem. Thanks Fred.