SQL Server Performance Forum – Threads Archive

NETWORK max capacity

where do i find out what is current network max capacity?
thank you

---

There is no direct answer to this. You can determine the network capacity of individual nodes but the net capacity will depend on the weakest link of network. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

---

True, the network capacity depends on other hardware like routers, hubs and other connected servers to the SQL Server. You can deploy capacity/load testing tools or other network related s/w to get the assesment. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

For a rough indication, Take a sizable backup file (say 100MB) place it on your source server, now copy it to the target server and see how long it takes to do the copy. 100MB at 10Mb/s = 80 sec
100MB at 100Mb/sec = 8 sec
100MB at 1000Mb/sec = 0.8 sec Those are theoretical minimum times, in reality expect up to 40% more You can check the speed of a card in a Windows machine, by using Performance Monitor. Choose the Network Interface counter and select the non-loopback value. NOTE if Network Interface is not listed as a valid counter, then instal SNMP as a service in Network Properties Cheers
Twan

---

Valid point by Twan and perform this action during peak hours on SQL server, so that you will get optimum results. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

Here I would like to mention that the available bandwidth is generally 40-50% for non-guplex connections and close to capacity for full duplex connections. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

---

Thank you

---

]]>