DX Infrastructure Manager

Expand all | Collapse all

identify hosts with most qos data

  • 1.  identify hosts with most qos data

    Posted 10 days ago
    hi guys,

    just curious if there's a quick and easy way to find out which hosts are producing the most qos data. We have a few thousand hosts and am curious if there are any probes in our fleet configured to check every second...


  • 2.  RE: identify hosts with most qos data

    Posted 10 days ago
    This is a small query to see what devices are creating the most qos metrics:
    SELECT top 15 sd.robot, count(sd.probe) '#qos'
    FROM S_QOS_SNAPSHOT ss with(nolock)
    JOIN S_QOS_DATA sd with(nolock) on ss.table_id = sd.table_id
    group by sd.robot
    order by #qos desc
    But this query will not show how many rows of data each device will produce. (this can be obtained on qos level)
    It will also not show the configuration setting if it's set to check every second, because this is set in the local config file or mcs profile.

  • 3.  RE: identify hosts with most qos data

    Posted 9 days ago
    Thanks as always Luc

    We've got one host that has over 180,000 qos records that doesn't even have a robot on it which we'll need to investigate. Otherwise the majority of "top" hosts are the UIM hubs as expected.

    Thanks again :)

  • 4.  RE: identify hosts with most qos data

    Posted 8 days ago
    Each RN_QOS_DATA_xxx table includes a samplerate column. It looks like that contains the # of seconds between samples. ​It's saved with each sample, so it's not a terribly convenient thing to check, especially because that also means it is split across all of the RN_QOS_DATA_xxx tables. But it may be useful to check at least some of those tables for rows that have an unexpected value in the samplerate column. That kind of query might be a bit slow too; I wouldn't necessarily expect that column to be indexed.