I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. I'm loading data from a local SQL Server instance to another local SQL Server instance. However, I use fully-qualified URLs to address the servers b/c it makes developing offline much easier. So, instead of
10.1.2.X I use
Am I taking a performance hit by using the external URL rather than referencing the database as
localhost\instance? Also, why am I seeing such high network traffic while these packages run? There's really nothing that should be going across the network.
Here's what my network traffic looks like in Resource Monitor while a job runs a package.
Obviously there's a lot of traffic moving around on the network, but the job that is running only reads and writes data from the same machine.