DX Unified Infrastructure Management

  • 1.  Database value for url

    Posted Sep 29, 2017 07:54 AM

    What does the database value "RN_QOS_DATA_0016" denotes for url_response probe?

    Does it show url down state or the up state?



  • 2.  Re: Database value for url

    Posted Sep 29, 2017 08:25 AM

    It depends what QOS is behind your RN_QOS_DATA_0016 table.

    The following query gives you an overview of all your RN tables with the QOS related name + other interesting values.

    And once you see the QOS name for your RN_QOS_DATA_0016 table, you can use the second query to have the latest (=current) values in that table.

    1 - qos details

    ------------------

    SELECT
    q.name as QOS,
    q.qos_group as [Group],
    q.unit as Unit,
    q.unit_short as Abbreviation,
    q.isbool as IsBoolean,
    q.hasmax as HasMax,
    t.NAME AS TableName,
    p.rows AS RowCounts,
    SUM(a.total_pages) * 8 AS TotalSpaceKB,
    SUM(a.used_pages) * 8 AS UsedSpaceKB,
    (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
    FROM
    sys.tables t
    INNER JOIN
    sys.indexes i ON t.OBJECT_ID = i.object_id
    INNER JOIN
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
    INNER JOIN
    sys.allocation_units a ON p.partition_id = a.container_id
    LEFT OUTER JOIN
    sys.schemas s ON t.schema_id = s.schema_id
    LEFT OUTER JOIN
    S_QOS_DEFINITION q ON t.name = q.r_table
    WHERE
    t.NAME NOT LIKE 'dt%'
    AND t.name like 'RN%'
    AND t.is_ms_shipped = 0
    AND i.OBJECT_ID > 255
    GROUP BY
    q.name,q.qos_group,q.unit,q.unit_short,q.isbool,q.hasmax,t.Name, s.Name, p.Rows
    ORDER BY
    RowCounts desc

    2 - for a qos give the latest metric details/values

    ---------------------------------------------------------------

    SELECT qd.origin,qd.robot,qd.qos, qd.source,qd.target,qs.samplevalue,convert(varchar, qs.sampletime, 120) sampletime
    FROM S_QOS_SNAPSHOT qs
    JOIN S_QOS_DATA qd on qs.table_id = qd.table_id
    where qos = 'QOS_URL_RESPONSE'
    order by qs.samplevalue