Solved

Question about how PSExec works

Posted on 2006-06-13
1
477 Views
Last Modified: 2009-07-29
Hi there,

I have recently created a .NET Service to automatically run a daily backup of all SQL Servers on our network.  We have a WAN that extends from Newfoundland, Canada to to Alberta, Canada.  There are 4 or 5 SQL Servers that are remote or not at our main office.  So, when the backups complete I am currently using PSExec to make a remote call on each of the remote SQL Servers to 1) run a Zip application to zip up the backups and 2) execute a copy command to copy the Zip files from the Sql Servers to two other locations for Disaster Recovery reasons, etc.  It appears as though the psexec application is casuing a HUGE amount of traffic from my pc on our network and is slowing down our remote sites that are using CITRIX to connect back here at the corporate office.  

So again here's the scenario:

1) Remote SQL Server in Calgary, Alberta (for example - 1 of 4 remote SQL Servers)
2) Local Backup Service running from St. John's, NL
3) The local service runs on a schedule performing full backups daily
4) When the backup completes, the service then uses PSExec to run a Zip application called MyZippa to zip the backup files on the remote server
5) When the zipping completes, the service then uses PSExec to execute the Copy command from the Primary Backup Location (I.e. a drive on the SQL Server) to the Secondary and Tertiary backup locations which are just remote PC's (not servers) in Calgary in the same building (so the pc's are local to the remote SQL Server - hehe).  

So it seems like the copy is actually bringing the files back here to St. John's and then sending it to the secondary and tertiary locations back up in Calgary from here which is not right.  Based on the amount of Bandwidth that this application is taking up, there's something not working properly.  Most users in Calgary are using CITRIX to run OFFICE programs and various other applications and our LAN Sniffer was saying that i was using 900 kbps of bandwidth while the copy was happening.  At that point, everything locks up or slows down horribly for the users in Calgary that are using CITRIX, etc.  

So, my question is this: how does PSExec run?  Shouldn't the copy command that it calls on the remote server run remotely only and not bring anything back over the wire to here?

any help or insight on this would be greatly appreciated.
0
Comment
Question by:FPIT
1 Comment
 
LVL 1

Accepted Solution

by:
Hyppy earned 500 total points
ID: 16894006
PSExec is like a Remote Desktop for the command prompt.  It uses the $ADMIN share on the remote computer to execute processes.  Yes, the copy command should work locally, and not necessitate access back to your system
3 points, though:
- Are all of the applications you are running with PSExec being run on the local computer, or accessed through a share?  The latter will introduce a lot of excess traffic.
- If you use PSExec with the /d switch, it will close the connection after the process is begun, which may alleviate some of the excess traffic.
- You may want to look into a possible routing issue.  It may not be PSExec at all, and in fact a misdirected route.  I am not familiar with your network infrastructure, so this could be completely out of the realm of possibility.  Just something to consider.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IT Asset Management 5 88
texting/mms service for clients 4 36
Looking for good Imaging Software 6 55
Software to convert png to .ico 17 14
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question