local network not work when internet notwork

My office network have 10 pcs we connect with adsl to internet with adsl router most of pc get ip from that router it have a machine is database server this is fix  ip I found that when internet is slow my database is slow too how can I fix this problem do i need to change router Please sugest
teeraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AkinsdNetwork AdministratorCommented:
Routers don't route packets as fast as switches do.
You can buy a layer 3 gigabit switch
Enable IP cef and ip routing on the switch
If your database has 2 NIC ports, configure etherchannel on it to increase bandwidth.
Another good thing to do is to make the switch your gateway, but you will need to know how to create a default route to your router

All the best
0
Cyclops3590Commented:
Ok, so if I'm understanding this.  This is your issue.  When your internet connection is up and stable, communication between your clients and your database (all self contained within the local area network, nothing going over the ADSL link) your speeds are fine.  But when the ADSL link goes down, then your inter-LAN traffic slows.

I would try to run some tests between computers using IP addresses only.  The only thing I can think of is that maybe your database server is configured to do something with DNS upon connections (I've seen that before where a server will do a reverse DNS lookup on the connecting IP address).  If that is the case and your internet is down it must wait for the DNS request to time out before it proceeds.  So it looks like a slow down when it really isn't.  It's just a process timing out. Since you get your IPs from the router, I assume that  you are using DNS servers not on your LAN as well which would explain those time outs when the ADSL link goes down

That's all I can think of anyway.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Network Analysis

From novice to tech pro — start learning today.