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

"Busiest hour"- type report

Does anybody have an idea as to how I can answer the following question:

What was the average (interface traffic) utilization during the busiest 15 minutes on a given link?

I'm mucking about with the report writer and just can't see how I can this info from the database. I want to refine it with time exclusions for business hours, filter for certain regions and so on, but I just can't seem to get anywhere before I understand how to come up with the answer to the question above. Maybe I need some SQL-skills.

/Lars

Lars Grabowski
Global Infrastructure
Chr. Hansen A/S

Find more posts tagged with

Accepted answers

All comments

Network_Guru

It Depends.

- What is the statistics polling frequency of your interfaces?
- How long are you keeping detailed statistics before rolling them into hourly stats?
- How far back is the report pulling the data?

The most detail the built-in reports will display is hourly data. Unless you are using
custom SQL queries, you won't be able to see the data in a 15 minute interval.

I believe the Report Writer was intended for trending and general historical reporting.
For the kind of granularity you are looking for, the web graphs would be a better option.

-=Cheers=-
NG

Grabowski

*The statistics polling frequency of my interfaces is 120 seconds
*I am keeping detailed statistics for 31 days before rolling them into hourly stats. (used to be 7 days up until last week)
*I'm hoping to be able to pull data a couple of weeks or mopnths time back.

I spoke with Solarwinds Support on Thursday last week, where we established that I can forget about getting local business hours across the globe into one single report. No way of handling the off-set. So, adjusting my expectiations, I wanted to still try and get busiest x-mins during business hours. We kept getting incorrect percent utilization (MAX) data back from the query though, but finally found out that this has to do with us asking for data that went further back in time than the setting for when data was being rolled up/summarized was set at.

Now I've changed the settings for when data is being rolled up from detailed to hourly from 7 to 31 days, hourly to monthly from 30 to 60 days, dailies deleted from 365 to 550 (the database will no doubt grow substantially). So in a couple of weeks time, I'll be able to make this query produce better averages

Basically, what I find is missing is some form of handling of time-zones. And also some sort of documentation of the database including how calculated fields are derived.

Lars Grabowski
Global Infrastructure
Chr. Hansen A/S