Identify engine constraint causing long running jobs to slow down

1 votes

Not blocking just annoying. Load any gigantic table and the longer it runs the slower it gets. Duplicate the job and run it while the slow job is still running and it runs very quickly while the original just chugs along. If whatever this is could be sorted out I could consolidate my transforms into less larger jobs.

16:22:43,946 1875000 rows populated.
16:22:49,629 still alive
16:23:20,754 1900000 rows populated.
16:23:49,629 still alive
16:24:33,686 1925000 rows populated.
16:24:49,629 still alive
16:25:13,172 1950000 rows populated.
16:25:49,630 still alive
16:26:49,630 still alive
16:27:38,865 1975000 rows populated.
16:27:49,630 still alive
16:28:13,274 2000000 rows populated.
16:28:49,630 still alive
16:29:49,630 still alive
16:30:49,631 still alive
16:31:49,630 still alive
16:32:49,630 still alive
16:33:49,630 still alive
16:34:49,630 still alive
16:35:02,899 2025000 rows populated.

Done Suggested by: Bryan Meyerovich Upvoted: 03 Aug, '20 Comments: 1

Comments: 1