number of CPUs per node

Database

number of CPUs per node

I know that my teradata database has got 2 nodes and 12 Amps. How can I find out the number of CPUs in each node?
7 REPLIES
Enthusiast

Re: number of CPUs per node

Hi,

exist many way's for verify this.
1 - Verify systems tables or open PMON and verify on the first screen (right superior side) "PentPro" ...
Click in the box and verify nodes by CPU....
Enthusiast

Re: number of CPUs per node

Try this
sel distinct NodeId, NCPUs
from DBC.ResGeneralInfoView;

Vinay
Enthusiast

Re: number of CPUs per node

I think that method would work only if RSS logging is turned on.

I suppose the most general method would be to look up the hardware specs for your server nodes. If those are not available for some reason, the operating system may have a tool for reporting such information. If the OS is Microsoft Windows, you can use System Information (under System Tools in the Accessories menu). With UNIX (either Linux or MP-RAS), the only method I know is to reboot the system and observe the hardware detection messages on the system console (or in the /etc/.osm file).

In general, the Teradata software is entirely unaware of hardware details such as the number of CPUs. Also, bear in mind that the number of CPUs is becoming an ambiguous concept with the advent of micro-threading and multi-core processors. In most cases, the OS will report the number of "apparent" CPUs (counting each micro-thread on each core) rather than the actual number of physical CPUs.
Enthusiast

Re: number of CPUs per node

Jim,

Thanks for highlighting. I forgot to include the RSS logging information in my earlier post.

But I think you gave more information.

Thanks,
Vinay

Re: number of CPUs per node

at the command prompt type, pinfo -v. this will
show how many CPU's & speed.
Enthusiast

Re: number of CPUs per node

Hi,

Its old thread, but still had simliar query on the same. Please help.

Resusage table says 48 CPU's per node.

As per the Teradata specs given to us it is 12 core 2 CPU's per node, so ideally it should be 24 CPU's per node which is not matching with counts in ResUsage.  Any info on how resusage tables calculates no of CPU's?

Thanks,

Sri

Teradata Employee

Re: number of CPUs per node

With HyperThreading enabled (two instruction pipelines per core), the number of "virtual CPUs" reported by the OS is twice the number of physical cores.