This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Difference between APM_ApplicationStatus vs APM_ApplicationStatus_Details - SolarWinds DB Table?

Greetings,

SolarWinds Database tables, do you know what is different between APM_ApplicationStatus vs APM_ApplicationStatus_Details. Seems like APM_ApplicationStatus stores more data up to 180 days while APM_ApplicationStatus_Details only provides 30 days worth of historical data?

Thank you

Parents
  • APM_ApplicationStatus is a SQL view that combines the data from the following tables:

    APM_ApplicationStatus_Detail
    APM_ApplicationStatus_Hourly
    APM_ApplicationStatus_Daily

    It is the output of the following SQL query:

    SELECT        [ApplicationID], [TimeStamp], [Availability], [PercentAvailability], 1 AS [RecordCount], 0 AS [Archive]
    FROM            dbo.APM_ApplicationStatus_Detail
    UNION ALL
    SELECT        [ApplicationID], [TimeStamp], [Availability], [PercentAvailability], [RecordCount], 1 AS [Archive]
    FROM            dbo.APM_ApplicationStatus_Hourly
    UNION ALL
    SELECT        [ApplicationID], [TimeStamp], [Availability], [PercentAvailability], [RecordCount], 2 AS [Archive]
    FROM            dbo.APM_ApplicationStatus_Daily

    You can view the retention periods of the tables here:

    SERVERNAME/.../Settings.aspx

  • Thank you shuth for your time. May I ask:

    1. What is the weight of each polling under APM_ApplicationStatus? Can I assume all entries carry equal weight?
    2. What does PollTime mean?
    3. Polltime.jpg
      Again I appreciate your time.Thank you!
Reply Children
  • 1. It shows all your availability data for your applications.
    The Detailed table shows your raw data (in your screenshot, the status every 5 minutes).
    The Hourly table is older data summarised into an hourly figure, show the average % availability for that hour.
    The Daily table is even older data that has been summarised into a single daily figure, showing the average % availabiltiy for that day.
    The APM_ApplicationStatus view brings all of that into one table.

    So you end up with something like:
    2020-04-26 09:20:18.863 100
    2020-04-26 09:15:18.863 100
    2020-04-26 09:10:18.863 100
    2020-04-26 09:05:18.863 100
    ...
    2020-04-13 11:00:00.000 100
    2020-04-13 10:00:00.000 50
    2020-04-13 09:00:00.000 100
    2020-04-13 08:00:00.000 100
    ...
    2020-01-26 00:00:00.000 100
    2020-01-25 00:00:00.000 100
    2020-01-24 00:00:00.000 100
    2020-01-23 00:00:00.000 100
    2020-01-22 00:00:00.000 100


    2. I don't know what PollTime means. Best guess would be how long it took to poll in microseconds but that's a complete guess.