HoustonGuy
Programmer
How much CPU usage is there when running a DTS package stored on one server, but the tables being manipulated are on another server?
The package does have some DDL, DML SQL scripts in it. (As opposed to calling a stored procedure on the other server.)
My argument is that the other server where the tables reside on will bare the heavy CPU usage. Not the server storing the package.
Thoughts?
The package does have some DDL, DML SQL scripts in it. (As opposed to calling a stored procedure on the other server.)
My argument is that the other server where the tables reside on will bare the heavy CPU usage. Not the server storing the package.
Thoughts?