Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CPU usage of a package using tables on another server

Status
Not open for further replies.

HoustonGuy

Programmer
Jun 29, 2000
165
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top