Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anthony.cole
Starting Member
3 Posts |
 Posted - 2008-08-21 : 04:59:32
|
| Hi,We seem to be experiencing slow network speeds between our SQL Server and all of our clients, it seems that the connection is topping out at 5mb/s each. We initially thought this was a network problem so we upgraded the switches between the server and the client to 1Gbps with no avail.Hardware:Microsoft Server 2003 x648GB RAM2 x 73GB 15k OS drives3 x 146GB RAID5 Data3 x 146GB RAID5 Transaction logsSQL Server 2000 Standard 32-bit editionAny help would be greatly apprechiated.Thanks,Anthony Cole |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-08-21 : 11:44:08
|
| Have you benchmarked the physical drives on the SQL server?All raid 5's are not equal.IO Meter is a great tool, but anything that can measure write speed will be useful. copy a 100mb file back and forth and time it. |
 |
|
|
anthony.cole
Starting Member
3 Posts |
Posted - 2008-08-21 : 14:15:58
|
| Yes, it will transfer data at 5mb/s to many clients at the same time until we reach the limit of the network card, but i'm sure we should get better if the server is only serving one client? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-21 : 23:14:15
|
| Are clients on same local network with server? What's NIC speed on server and client machines? |
|
|
|
anthony.cole
Starting Member
3 Posts |
Posted - 2008-08-22 : 04:05:04
|
| Yes, the server has a 2gig connection to the switch and the heavy data users then have a gig connection to the switch. (Gigabit switch) |
|
|
|
|
|
|
Slow Transfer