Solved

Question about how PSExec works

Posted on 2006-06-13
1
487 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Suggested Solutions

Title # Comments Views Activity
Denali Software 2 83
Map software access 4 55
CRM Online Report - Passing Parameter from Opportunity to Report 1 48
Need advice on an App idea......but who do I ask? 2 69
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
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 successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

734 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