Hello,

I have extensive set of inserts - over 130 thousands. It is split into 4 files - three with 32500 inserts, fourth wit the rest, all running in paralel.

Execution runs just fine until completion. After counter hits 32500 of 32500 in the file I wached the result sub-window tries to show and whole ADS freezes solid. After some time Execution monitor tries to pop up (I have monitor for long running querries - 5 minutes I think), but i think that it tried to show noticeably later (5 minutes after freeze of ADS?).

Internally it seems that all 4 scripts finished running since all data are present.

Execution time reported by ADS is 3m 31s.

I am connecting to SAP ASE 16.0 SP04 PL01 HF01: 'Adaptive Server Enterprise/16.0 SP04 PL01/EBF 29702 SMP/P/AMD64/Windows 2012 R2/ase160sp04pl01x/0/64-bit/FBO/Wed Jul 21 17:41:43 2021'

Performance monitor keeps varying, like it is trying to do work...

If I can provide more info I will be glad to do so.

Sincerelly yours,

Michal

Hello,

I have extensive set of inserts - over 130 thousands. It is split into 4 files - three with 32500 inserts, fourth wit the rest, all running in paralel.

Execution runs just fine until completion. After counter hits 32500 of 32500 in the file I wached (the first which started running) the result sub-window tries to show and whole ADS freezes solid. After some time Execution monitor tries to pop up (I have monitor for long running querries - 5 minutes I think), but i think that it tried to show noticeably later (5 minutes after freeze of ADS?).

Internally it seems that all 4 scripts finished running since all data are present.

Execution time reported by ADS is 3m 31s.

I am connecting to SAP ASE 16.0 SP04 PL01 HF01: 'Adaptive Server Enterprise/16.0 SP04 PL01/EBF 29702 SMP/P/AMD64/Windows 2012 R2/ase160sp04pl01x/0/64-bit/FBO/Wed Jul 21 17:41:43 2021'

Performance monitor keeps varying, like it is trying to do work...

If I can provide more info I will be glad to do so.

Sincerelly yours,

Michal