Examples: Using MonitorSQLCurrentStepSV - Teradata VantageCloud Lake

Example: Using MonitorSQLCurrentStepSV with Default Query

This query requests the current SQL step for this session from the specified host.

SELECT * from MonitorSQLCurrentStepSV(
  USING
    HostIdIn('10001')
    SessionNoIn('1007')
    RunVProcNo('30719')
) AS dt;

The output looks similar to this.

       HostId        10001
    SessionNo         1007
  DynamicPlan       0
PartialSteps       0
   NumOfSteps       3
CurLvl1StepNo       1
CurLvl2StepNo       1
       ZoneId            0
       SPName
     SPDBName

DefaultDBName tdaas_cloudfabric1

Example: Using MonitorSQLCurrentStepSV with Detailed View Query

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

SELECT * from MonitorSQLCurrentStepSV(
  USING
    HostIdIn('10001')
    SessionNoIn('1007')
    RunVProcNo('30719')
    details('1')       
) AS dt;

The output looks similar to this.

       HostId        10001
    SessionNo         1007
  DynamicPlan       0
PartialSteps       0
   NumOfSteps       3
CurLvl1StepNo       1
CurLvl2StepNo       1
       ZoneId            0
       SPName
     SPDBName

DefaultDBName  tdaas_cloudfabric1
ParentSessionNo 2016
         Type  compute cluster
           Id  sys-784f2c302a_pog_784f2c1087_group_1_cog_1_0b1osq
         Name  1-0b1osq
        Group  pog_784f2c1087_group_1