Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

Sql traffic transversing accross different switches 500 points

I have two servers, lets call one Sql01 and one collect01.  These two servers are plugged into the same HP switch.  Just yesterday I noticed that when these two servers sync their sql databases that the traffic goes through the whole lan across 5 or more different switches.  The Network switches have been up for over 100 days so they should know where to pass the packets.  They sync up every morning and my monitoring tools (monitoring internet usages) bumps up to about 20 mbit per second for almost an hour.  I also notice other traffic going from server to server or computer to server pass through my Internet switch port, although its not as noticable

Please let me know what could be configured wrong in my office lan.

Thanks
0
dwolford
Asked:
dwolford
  • 6
  • 4
1 Solution
 
prashsaxCommented:
How are you monitoring you network traffic.

Have you used port mirroring on this switch to capture the traffic.

Did you tried capturing data from one of the other machines connected on the same switch on in the same subnet.
0
 
dwolfordAuthor Commented:
I am using ntop and iptraf to monitor net traffic.  Yes, I use port morroring from the port that connects to my internet router to my linux server which is doing the monitoring.

The monitoring/internet switch is about 3 switch hops away from the server traffic.

The only other machine capable of monitoring on the same switch as the servers is also mirroring traffic so that I can monitor server traffic.
0
 
johanvz1Commented:
Hi,

Is this a managed or unmanaged switch?. I would suggest a direct vlan between these two servers don't know if it will work my switch experience is minimal.

Rgds,

Johanvz1
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
dwolfordAuthor Commented:
They are all managed switches.  As long as by managed you mean being able to connect into them via telnet or web access.  Setting up a vlan between them is just a temp fix as other servers/computers do the same thing I just hardly notice it.

With switches, traffic should only go to the port of the mac address of the machine it has in its arp table which, unless its a broadcast.  I want my network to work like a well oiled machine.

Thanks
0
 
prashsaxCommented:
is it possible, that you are able to see traffic because you are connected to a mirrored port.

As far as traffic increasing to 20Mbps, so that will happens when you trasfer files on network.

The only way to be sure that traffic is being boradcast on entire network is to put a network sniffer(ethereal) on a normal machine and then try and see what packets are coming to this machine. If you are able to see the replication data on this machine as well, then their is a problem.
0
 
dwolfordAuthor Commented:
Traffic should not even get to the swtiches that i'm at.  The switch that I'm monitoring and giving you this data is 3 to 4 switch hops away.  Data should not be replicated to multiple switches like this

(Switch)------------------(Switch)-----------------(Switch)----------(Switch)
   /     \                                                                                           /
sql01  collect01                                                                           Monitoring


I hope my little diagram posts correctly.
0
 
prashsaxCommented:
Yes, your diagram is posted nicely.

You are right. Data should not reach your switch.

But their could be a scnerio when this could happen.

have you setup all switches yourself.

Because, if you haven't then it could be possible that someone has configured all the switches in a way that you can monitor your entire network from one point.

Have you tried capturing traffic on some other port.


Switch)------------------(Switch)-----------------(Switch)----------(Switch)
   /     \                                                            /                             /
sql01  collect01                                               PC                   Monitoring

If possible, could you do it on a pc like this.
0
 
dwolfordAuthor Commented:
I setup most of the switches myself and I have configured the others to make sure they are setup properly.  Currently all my linux machines are tied up at the moment.  But again, its just not those two servers talking that I am seeing.  
0
 
prashsaxCommented:
Yes, I know, you must be able to see all the traffic from your lan.

You can use ethereal on windows XP machines, if you have one free.
0
 
dwolfordAuthor Commented:
I'll see if I can get time to do that.  I would really like to speak to someone that has had this sort of thing happen to them before on hp switches.
0
 
dwolfordAuthor Commented:
It seems that the traffic has stopped being bounced accross the whole network
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now