Bandwidth report of one host on router

Unanswered Question
Jan 19th, 2010
User Badges:

Hi, I have one 7200 Series router and I have internal network 10.32.0.0/16 for data and 10.35.0.0/16 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, 10.32.111.15 IP. I want to know how much WAN bandwidth this application is taking.


How can I do it ? Any idea?


Regards,

Rupesh

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Giuseppe Larosa Tue, 01/19/2010 - 07:46
User Badges:
  • Super Silver, 17500 points or more
  • Hall of Fame,

    Founding Member

Hello Rupesh,

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


wait some time then issue

sh ip accounting | inc 10.32.111.15


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

Giuseppe

Edison Ortiz Tue, 01/19/2010 - 08:05
User Badges:
  • Super Bronze, 10000 points or more
  • Hall of Fame,

    Founding Member

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 10.32.111.15


class-map SQL

match access-group 99


policy-map WAN-QOS

class SQL

bandwidth percent 10


interface fx/x

service-policy out WAN-QOS


Regards


Edison

Giuseppe Larosa Wed, 01/20/2010 - 00:20
User Badges:
  • Super Silver, 17500 points or more
  • Hall of Fame,

    Founding Member

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

Giuseppe

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

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
      Queueing
      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
User Badges:
  • Super Bronze, 10000 points or more
  • Hall of Fame,

    Founding Member

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.


Regards,


Edison

Actions

This Discussion