October 10, 2001 at 2:58 pm
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.
Bill
October 10, 2001 at 4:02 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy