Question Locked

Need help with network switch layout

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We currently have 6 servers connected to an 8 port GB unmanaged central switch. The remaining 2 ports on this switch connect to 2 more 24 port unmanaged switches. These switches are where all the user workstations are connected to.

We are having an issue with 1 server. It is our SQL reporting server, and whenever large reports are run it tends to slow down the entire network including shared drives on other servers. I didn't think it should affect other drives, since they are located on an entirely different server...but, I assume since all servers are tied into the central switch, there must be an overload of some sort when large data is passed during these large SQL reports...am I correct?

And, if I am correct...is there a better way to setup my switch layout? Do I need to run the SQL server on an entirely seperate switch apart from the other servers? Will this improve network performance during peak periods?

jho

6 replies

by maniacman

If the SQL server slows everything else down, then to me that says that your single broadcast domain is getting flooded with traffic. What I would do is to get Layer 3 switches and create a separate VLAN just for the SQL server so that any broadcast traffic will be confined to that VLAN and won't spill out onto the other subnets. Run a packet trace on your existing subnet using WireShark and you'll see what's going on.

by jeffrey.ho

I believe our switches are all layer 2. What is the difference between layer 2 and 3? What steps do I need to take to setup a VLAN?

jho

by maniacman

Layer 2 switches work at the data link layer and only store MAC to IP information in what's known as an ARP (address resolution protocol) table. In a layer 2 switch, there is only a single subnet and that single subnet is a single broadcast domain. Ethernet is a contention based communications protocol, so everything on a single broadcast domain will listen to and talk to everything else on that subnet. Think of it as people being jammed into a single room and everyone's talking at the same time.

Layer 3 switches go one step further in that they can operate up to the Network Layer and act as routers through the use of VLANs' or virtual LAN's. A VLAN is basically a logical subnet in your physical LAN, so that you can have a single star topology and have multiple subnets that way (e.g. multiple rooms with people talking and nobody can hear people in the other rooms, as each VLAN is its own broadcast domain). With a layer 3 switch, each port can be assigned a VLAN ID, which in itself translates to a subnet and mask , and then there is a default gateway for each VLAN so that it knows how to talk to other VLANs'. A layer 3 switch is basically a switch that can route traffic internally to other VLANs', since each VLAN is it's own broadcast domain or isolated subnet.

You can't convert Layer 2 switches to Layer 3, as you'll need to buy completely new hardware to support Layer 3. Cisco 3750 switches and the larger enterprise Catalyst 6500 switch chassis support Layer 3 with the appropriate blades.

by jeffrey.ho

Why couldn't I just purchase managed layer 2 switches? I have looked at a couple, and they all support creating VLAN's.

So let me ask you this. If I created a VLAN, and I assigned my SQL server to it, and I also included the few users who regularly access the server...none of this traffic would affect any other servers? We run an http report server where these users go to run the SQL reports, would the VLAN have any affect on this?

I guess I'm just wondering exactly who and what I would include in this VLAN?

jho

by the listed 'g man'

otherwise the SQL server will not be able to connect with any of the workstations as it is on another VLAN.

Replace VLAN with LAN and you see my point. The L3 Switch acts as a router. The other option is to install a router to seperate the two LANS (Old and new SQL LAN) and use your existing L2 switches.

This discussion is closed to new replies.