Bandwidth report of one host on router

Unanswered Question
Jan 19th, 2010

Hi, I have one 7200 Series router and I have internal network for data and for voice. We have MPLS for external link having BGP on that.  I have configured QOS polices for Voice and Data network. I have Solarwind as NMS which is monitoring the links and giving detail of bandwidth utilized on the interface.

Now I have installed on SQL application in inside network, IP. I want to know how much WAN bandwidth this application is taking.

How can I do it ? Any idea?



I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Giuseppe Larosa Tue, 01/19/2010 - 07:46

Hello Rupesh,

an ACL with log option or ip accounting output-packets on exit interface.

wait some time then issue

sh ip accounting | inc

doing this over time you can get a measure of traffic originated by this ip address

other ideas are possible like using netflow to get top talkers information

Hope to help


Edison Ortiz Tue, 01/19/2010 - 08:05

You can create a class-map to match the source IP address for this server.

You can refer to this class-map under the policy-map and provide CBWFQ for this application.

Doing so will create a separate category for this application so you can use your NMS appliance for tracking purposes.

For instance:

access-list 99 permit host

class-map SQL

match access-group 99

policy-map WAN-QOS

class SQL

bandwidth percent 10

interface fx/x

service-policy out WAN-QOS



Giuseppe Larosa Wed, 01/20/2010 - 00:20

Hello Rupesh,

you can use

sh policy-map int f0/0

you will get rates and cumulative counters for each traffic class including the SQL class

Hope to help


Rupesh Kashyap Wed, 01/20/2010 - 01:02

Ok, below I have configure 60% bandwidth for SQL. How can I calculate the bandwidth used by this, what would the time interval.

Class-map: SQL (match-any)
      1294224644 packets, 101573999974 bytes
      5 minute offered rate 830000 bps, drop rate 0 bps
      Match: access-group name Citrix
        1294224642 packets, 101573999743 bytes
        5 minute rate 830000 bps
      queue limit 1024 packets
      (queue depth/total drops/no-buffer drops) 0/0/0
      (pkts output/bytes output) 13429021/1062276628
      bandwidth 60% (6000 kbps)
      QoS Set
        dscp af42
          Packets marked 1294224647

Edison Ortiz Wed, 01/20/2010 - 06:59

Your output indicates a 5min average of 830kbps (5 minute offered rate 830000 bps, drop rate 0 bps)

You may want to change the load-interval in the interface(s) to 30seconds to get a better read on the bandwidth consumed by the application.




This Discussion