Solved

Question about how PSExec works

Posted on 2006-06-13
1
471 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

839 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