nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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
Store

fluctuation in interface traffic utilization

MC_Tools

I was wondering if anyone has setup this alert with the following condition:

Interface receive/send utilization has changed by 10% or more over the past 24 hrs. I'm more interested in increase of utilization than decrease.

Any ideas guys?

thanks,

Find more posts tagged with

advanced_alert_setup_question

Accepted answers

mrxinu

Before I start into this, the right way to find traffic changes is with something like the Holt-Winters algorithm:

http://www-iepm.slac.stanford.edu/monitoring/forecast/hw.html

Since we're not going to try to hack that up in T-SQL, the alternative is to compare the traffic you see on the interface now vs. what it was 24 hours ago. This is assuming that the traffic is pretty consistent from one day to the next - it might not be so on a Sunday/Monday.

Create two interface custom properties - tx_delta, rx_delta.
Create a stored procedure (mc_traffic_delta) that calculates the difference between the current tx and rx values and update those fields in the interfaces table.
Run the stored procedure as a trigger on the table that contains the traffic values (would have to look for this one - it might be the interfaces table itself or something nearby - you can use the report writer's "show sql" option when you're viewing one of the interface traffic reports to find it).
Create an alert that triggers on the values in the tx_delta or rx_delta values changing too much in either direction.

I haven't tried this myself, but I'm familiar enough with all the moving parts that as long as you're alright with the 24-hour span view it should work for you.

All comments

mrxinu

There's no out of the box method to get an alert to fire when the utilization has changed over 24 hours.

That being said, I can tell you how to generate a report for one of your views with the information, or give you an offroad suggestion that gets you an alert, but involves an hour of your DBA's time.

Interested in either of those?

MC_Tools

That would be appreciated alot. Would you mind posting or sending the instructions?

thanks.

mrxinu

Is it sufficient to throw that information up on one of your views in a report format or do you need to leverage alerts against it?

MC_Tools

To leverage alerts would be cool as we only run the reports once a week.

mrxinu

Before I start into this, the right way to find traffic changes is with something like the Holt-Winters algorithm:

http://www-iepm.slac.stanford.edu/monitoring/forecast/hw.html

Create two interface custom properties - tx_delta, rx_delta.
Create a stored procedure (mc_traffic_delta) that calculates the difference between the current tx and rx values and update those fields in the interfaces table.
Run the stored procedure as a trigger on the table that contains the traffic values (would have to look for this one - it might be the interfaces table itself or something nearby - you can use the report writer's "show sql" option when you're viewing one of the interface traffic reports to find it).
Create an alert that triggers on the values in the tx_delta or rx_delta values changing too much in either direction.

I haven't tried this myself, but I'm familiar enough with all the moving parts that as long as you're alright with the 24-hour span view it should work for you.

Eitan

Hi there

little less experiance with creating procedures can you elaborate on the howto?

Thanks EItan.

mrxinu

Without testing it myself I wouldn't be comfortable handing you a procedure off the top of my head. DBAs do this all the time, so if you can bribe one for an hour of his time that's probably your best route. They can be pretty involved if you're not comfortable in SQL Studio.

This is a pretty good primer if you want to check it out:

http://databases.about.com/od/sqlserver/a/storedprocedure.htm