Increase Lan Speed to database

Windows 2003 SBS - serial ata 7200 HD
15 Clients all connected by 10/100 switch - Cat 5

I am looking to increase our access speed to a database on the sbs server. My plan was to install gigabit NIC cards and add a 1gigabit switch for all to connect to.

Will this make respond times faster for clients? Do I need to change the Cat5 cable also? Looking for recommendations on improving Lan speed.
DaboysAsked:
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.

ruready511Commented:
Do you have CAT-5 or CAT-5e, because CAT-5e will support 1000Base-T (Gb) network speeds. Regular CAT-5 on a 1000Base-T network will be problematic.
I think your biggest problem is the RPM of the disk. If there are several 7200RPM drives in an array, you will be fine. But one drive, or any number of independent disks NOT in an array, is going to really slow down access speeds, especially if your connection involves multi-user concurrent access to the database.
Another thing you can do to help things along is to make sure your users are not opening files from across the network. Have them copy the files first to the local machine and then; a) re-upload the file to the file server, or b) sync the local copies with the source copy on the file server.

I hope this helps...
0
DaboysAuthor Commented:
I have Cat 5e. What disk drives and raid setup do you recommend? We need about 50gig of space.
0
ruready511Commented:
For your situation, I would reccomend getting 4 32GB IBM UltraStar 10000RPM hard drives set up in a RAID 5 configuration (with a hardware controller, you don't want to use software RAID on a server).
This should give you plenty of space and and room to grow; it will also provide very fast access to your database over the network (assuming Gb operating speeds).
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

DaboysAuthor Commented:
Can you recommend a good raid hardware controller?
0
YGregersenCommented:
Great point about the Hard Drive ruready511.

However, I could argue that for the amount of clients and connections that 4 Ultra SCSI drives would not be necessary. Plus, it puts Daboys' server down a long term hardware commitment into an expensive and narrow path. If the Database or anything else that server is hosting grows, 4/32 = 128GB of space is not going to last long. Going SATA gives the options of much bigger drives and they are usually significantly lower cost. Plus there are 10K RPM dives available in SATA options. But I guess its all about budget too.


Adding new gigabit NICS can help with overall overhead, especially if your folks are accessing other things on the LAN besides the database.. A lot of new NICS take less CPU overhead.
I would recommend getting a gigabit switch that can handle Jumbo packets also. Then you go into the hardware properties of the NIC and increase the packet size. Usually you can set it to near  twice the size. A newer switch will usually be helpful too because it can handle errors and collisions better.

How much RAM is on this server?

0
ruready511Commented:
Adaptec and Intel make good controller cards, just make sure that you pay around $200 for one. You don't want to go cheap on something that's going to provide you with all your data and subsequent backups.
0
robdcoyCommented:
You can also look into network teaming.  This is where you have two or more network cards acting as one logical connection.  There are a couple of modes that you can use; Fault Tolerance and Load Balancing.  You would want the Load Balancing.

Cheers,
Rob
0
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
Microsoft Hardware

From novice to tech pro — start learning today.