Question about how PSExec works
Posted on 2006-06-13
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.