Hi,

I've a strange behavior on my server.
I've a lot of packages to execute. (I've 1 big package which execute all
other packages, near 80 to execute)

A day all works fine, and the next execution the same package on the same
data takes 10 more times !
Normally in 1hour all is done.
actually, after 1hour of process only 1/3 of the data are processed!!

Processing 1000rows takes 30seconds instead-of 10 000rows / second in a
normal process!
Also, at the same time, another package appear to be locked, but I don't see
any lock (using sp_who2)

Why sometimes all works fine and another time there is some problems?
how to diagnostic the problem?

thanks.

Jerome.

Jéjé,

I had a similar problem a while back. What saved me was updating statistics
on all tables involved at the end of the run. Once I did that run times
stabilized.

Ilya

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

I allways update stats at the end of each packages

For example, yesterday, I've executed 1 time the process and canceled it
after 2hours and only 1/3 of the data processed.
Then I've reexcuted the same package just after my cancel, and then the
process has be done in 1h!

"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> wrote