Solved

Question about how PSExec works

Posted on 2006-06-13
1
445 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
Comment Utility
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now