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 |
|
nhuanlieu
Starting Member
27 Posts |
 Posted - 2009-08-10 : 12:09:32
|
| Hello folks, we have a situation that needs inputs for SQL/network gurus.Server A - PROD SQL2005 SP3 on Win2003Server B - TEST SQL2005 SP3 on Win2003NetAppliance - a simple and dumb net appliance storage unit that holds SQL backup files from Server AAll 3 units shared the same 10/100MB switch and all used 2000/FULL duplex.Situation: trying to restore a 16GB SQL BAK file toServer B from NetAppliance. During the restore, the Server A's NIC thru-put traffic jumped from 50K/s to 76MB/s and clients in Server A notice response time dropped during the restore. The SQL restore uses an UNC command (\\NetAppliance\C$) to pull files.Notice: when we copied the 16GB file raw using Windows copy, it when very fast and doesn't affect performance noticebaly.Curious question: can anyone take stab at it as to why is it Server A is affected when it does not involves in the restore process other than sharing a switch? |
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 09:15:42
|
| Clearly this stumped people :) And it stumped me! Did you every find anything out as to why?========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
 |
|
|
|
|
|
Server is affected when it does not involves