DTS Performance issue

  • I wrote a DTS (SQL 7) script whose last step invokes a stored procedure. On my Dell workstation it processes 100K records in 2 minutes. But when I transfered the DTS package to two other machines, and used the same 100K records, the stored proc step slowed to a crawl. (I had to kill the DTS packages -- 10 minutes of execution at 100% CPU utilization is no fun).

    Any ideas much appreciated.


  • Can you give us a better idea of what is inside the packages? Is it a single connection/T-SQL task?

    Also, what is different about the client machines? Did you check to see that some other process was not holding up the sproc? Perhas a transaction was not complete? Did you check locks?

    Steve Jones


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply