Examples: Using MonitorPhysicalConfigSV - Teradata Vantage

Example: Using MonitorPhysicalConfigSV with Default Query

SELECT * from MonitorPhysicalConfigSV() AS dt;

The output is similar to this.

    ProcId        10001
    Status  U
   CPUType  Xeon
  CPUCount      16
SystemType  6700V
  CliqueNo       0
    NetAUp
    NetBUp
PhyMemory        63141
    ProcId        20001
    Status  U
   CPUType  Xeon
  CPUCount      48
SystemType  6700V
  CliqueNo       0
    NetAUp
    NetBUp
PhyMemory       190818

Example: Using MonitorPhysicalConfigSV with Detailed View Query

The detailed view adds the Type, Id, Name, and Group columns to identify the source of these metrics.

SELECT * from MonitorPhysicalConfigSV(
    USING
    details('1')
) 
AS dt;

The output is similar to this.

    ProcId       10001
    Status U
   CPUType Xeon
  CPUCount     16
SystemType 6700V
  CliqueNo      0
    NetAUp
    NetBUp
PhyMemory       63141
      Type primary cluster
        Id pog-784f2c715b
      Name 1
     Group ?
    ProcId       20001
    Status U
   CPUType Xeon
  CPUCount     48
SystemType 6700V
  CliqueNo      0
    NetAUp
    NetBUp
PhyMemory      190818
      Type compute cluster
        Id sys-784f2c8afd_pog_784f2c715b_group_1_cog_1_setwlc
      Name 1-setwlc
     Group pog_784f2c715b_group_1