Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Server is affected when it does not involves

Server is affected when it does not involves

Server is affected when it does not involves

Hello folks, we have a situation that needs inputs for Windows network admins.

Server A - PROD SQL2005 SP3 on Win2003
Server B - TEST SQL2005 SP3 on Win2003
NetAppliance - a simple and dumb net appliance storage unit that holds SQL backup files from Server A

All 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?

RE: Server is affected when it does not involves

what are the NIC settings on the server?

RE: Server is affected when it does not involves

Name    [00000001] HP NC7782 Gigabit Server Adapter    
Adapter Type    Ethernet 802.3    
Product Type    HP NC7782 Gigabit Server Adapter    
PNP Device ID    PCI\VEN_14E4&DEV_1648&SUBSYS_00D00E11&REV_10\4&82820FC&0&1038    
Last Reset    8/9/2009 5:19 AM    
Index    1    
Service Name    q57amd64    

Here's an image. I think that is what you are looking for.

RE: Server is affected when it does not involves

You probably have packet loss on the network, wich thends to get worse quickly as more date is send trough the line. This would explain why the file transfer seem to be unaffected, as it's reasonable light-weight traffic compared to UNC.

- Open a ping from the machine accessing the UNC to the machine it is accessing it from. See if there are any problems. Now with the ping still open ( use -t on windows to keep it from quitting after 3 runs) start transfering data and see if if that has any effect on it.

- Errors caused by network connectivity can cause this. Mismatched MTU sizes or truncation of a packet at a router can result in this error when files larger than the largest packet size are copied over the network. In essence, the network connection is the media that has the physical problem.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close