Re: Slower performance in ActiveXscript task
- From: JXStern <JXSternChangeX2R@xxxxxxx>
- Date: Tue, 16 Jan 2007 08:24:26 -0800
On 16 Jan 2007 03:31:11 -0800, "yinthomas@xxxxxxxxx"
<yinthomas@xxxxxxxxx> wrote:
I implement an ActiveXscript task in a DTS package for looping several
store procedures in SQL 2000. The task run normally (around half an
hour) in the past half an year. However, without any changes of the
DTS, the processing time of this task increased significantly to one
hour. After 2 days, the processing time increased to 2 hour. I would be
grateful if anyone can help for such strange case in DTS task.
Need more hints!
It does seem odd, are you certain it's not the SP's which are running
more slowly? Or is there anything else on the same machine, that is
using CPU - ActiveX can use a lot of cpu. Or, did you switch from
running on a fast machine to running on a slow machine? Or did you
switch from running on the database server to running remotely?
J.
.
- References:
- Slower performance in ActiveXscript task
- From: yinthomas@xxxxxxxxx
- Slower performance in ActiveXscript task
- Prev by Date: DTS error--Microsoft Data Transformation Services (DTS) Data Pump
- Next by Date: Re: Slower performance in ActiveXscript task
- Previous by thread: Re: Slower performance in ActiveXscript task
- Next by thread: Re: Slower performance in ActiveXscript task
- Index(es):
Relevant Pages
|
