3 Replies Latest reply on Jan 10, 2020 1:12 AM by Kshamadan Kalligudd

    Need the infomation of Table names on the TSCO Database

    Kshamadan Kalligudd
      Share This:

      Hi Team,

      We need information of the table names to retrieve the basic metrics from the TSCO Database.

      Basically we are looking for the below metrics

      System performance :
      • CPU Utilization
      • Memory Utilization
      • Disk Utilization

      Network Performance:
      • Inbound Utilization
      • Outbound Utilization
      • Read And Write

      Note: FYI. We have indentified few table names just wanted to cross check for the same.

      Below are sample queries to get the data for CPU and Memory paramerts . Kindly check and let us know

      select b.name, b.metric, b.metricname, a.* from pv_sys_data_d a ,pv_sys_metric b where a.sysmetricid = b.sysmetricid and b.name = 'server_name' and b.metric='CPU_UTIL' and a.ts > sysdate-3;
      select b.name, b.metric, b.metricname, a.* from pv_sys_data_d a ,pv_sys_metric b where a.sysmetricid = b.sysmetricid and b.name = 'server_name' and b.metric='MEM_UTIL';

      Thank you.
      Regards,
      Kshamadan

       

      Message was edited by: Kshamadan Kalligudd