[dba-SQLServer] Gigabit switch

I got my 8 port gigabit switch today.  With that switch the entire dynamic
of my SQL Server experience changes.  Prior to this the fastest method of
importing using DTS was to have the raw data files on a disk on the SQL
Server and have the server machine itself load the data into the database.
I would average about 40k records per minute in that configuration.

My other new machine running DTS inserting records into the server didn't
work much if any slower, but it also didn't work any faster.  Now, with the
gigabit switch, having the second new machine run DTS on files local to that
machine dumping the data into the server is close to twice as fast as having
the server doing all of the work.  Furthermore, and I don't understand this,
having the second new machine running DTS and simultaneously performing
another task such as unzipping one of the raw text files used to slow the
DTS to a crawl.  With the gigabit switch the DTS slows down slightly, just
barely noticeable) but the other task proceeds at full speed as well.

Not to mention that I am also uploading all the data from my wife's laptop
to a usb disk on the server in preparation to format / reinstall that
machine.  

It sure sounds like I had a LAN bottleneck which I have opened way up.

8-)

John W. Colby
www.ColbyConsulting.com