Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Movement of data between ResponseTime_Detail, ResponseTime_Hourly and ResponseTime_Daily

Hi all. I've got a question about monitoring uptime. My requirement is to generate a report that lists availability M-F, 8-5. I'm thinking I simply query ResponseTime_Hourly and I should get what I need. However, there does not seem to be any data in that table.

The setup I've got is:

1) detail statistics summarized to hourly every day.

2) hourly summarized to daily every day.

3) daily stats deleted after 180 days. My question is when the results are summarized from detail->hourly are they deleted from the detail table? Similarly with hourly->daily?

The way the tables look at the moment I'm afraid that the data is deleted from the detail upon summarization to the next level. If that's true then I made a bit of a mistake in my setup

Any help is appreciated. Regards, Dave

Find more posts tagged with

Accepted answers

All comments

cdoyle

Hi Dave,

Yes, the data is removed from one table when it is summarized into another.

If you need a report for Node Availabilty, why not use the canned Availability reports from Report Writer? These can be edited to include filters for the Hour of Day, and Day of Week as neccessary. Alternatively, you could try working with the "ResponseTime" View, which is a union of all three tables.

~ Caroline

FormerMember

Hi all. I've got a question about monitoring uptime. My requirement is to generate a report that lists availability M-F, 8-5. I'm thinking I simply query ResponseTime_Hourly and I should get what I need. However, there does not seem to be any data in that table.
The setup I've got is:
1) detail statistics summarized to hourly every day.
2) hourly summarized to daily every day.
3) daily stats deleted after 180 days. My question is when the results are summarized from detail->hourly are they deleted from the detail table? Similarly with hourly->daily?
The way the tables look at the moment I'm afraid that the data is deleted from the detail upon summarization to the next level. If that's true then I made a bit of a mistake in my setup
Any help is appreciated. Regards, Dave

You are correct this is your problem. reset to keep your detailed for 7 days and hourly for 30days and daily for anything beyond that but understand the limitation is how far you can go back and putt historical data. the other thing you have to be careful of is how long you keep the more detailed data will directly correspond to how large your database gets. Keeping detailed longer will make it grow very fast and keeping hourly longer will grow it but not nearly as bad. This will give you good data for pulling information weekly for your report with the settings I suggested.

davehaas

Thank you for all the help.

I've adjusted the settings and I think we're off to the races

Dave