elovelo

Hello J.P. the proc 'sp_sysmon_appmgmt_V16SP3' indeed is missing. Can you share its code, please ? As for the archive/monitored server versions. I got the blank output for parallel query management also for monitored servers that are in the same version as the archive version. The only difference is the line about used procedures: Sampling Started at : Dec 9 2025 11:56PM Sampling Ended at : Dec 10 2025 11:27AM Sample Interval : 41466 s Nb transactions : 2327036 Counters Last Cleared : ASE days running...

Hello J.P. To be clear, my archive server runs on 16.0 SP02 PL07 part of my monitored servers are also in 16.0 SP02 PL07 and part of them are in 16.0 SP04 PL06 HF1. The server that I am interested in checking its Parallel Query Management is of 16.0 SP04 PL06 HF1. The query select top 1 ASE_Version from xxx_SysMonFl2 where Timestamp= (select max(Timestamp) from xxx_SysMonFl2) corresponds with the server version. Indeed the SysMon.xml and SysMonFld.xml collectors were disabled. I enabled them and...

Hello J.P. To be clear, my archive server runs on 16.0 SP02 PL07 part of my monitored servers are also in 16.0 SP02 PL07 and part of them are in 16.0 SP04 PL06 HF1. The server that I am interested in checking its Parallel Query Management is of 16.0 SP04 PL06 HF1. The query select top 1 ASE_Version from xxx_SysMonFl2 where Timestamp= (select max(Timestamp) from xxx_SysMonFl2) corresponds with the server version. Indeed the SysMon.xml and SysMonFld.xml collectors were disabled. I enabled them and...

Hello JP, the result is '16.0.04.06' I ran the query against all the rest of XXXXX_SysMonFI2 tables and the results correspond with the version of the monitored ASE.

Hello J.P. I run Asemon v3.2.3 on SAP ASE 16.0 SP02 PL07 I want to view the 'parallel' section of Sysmon for ASE in that is in version 16.0 SP04 PL06 HF1, but it in empty (see attached ss). I searched for any relevant collector in the <ase_name>.xml file that maybe needs to be enabled, but I did not find anything. It's the same for other ASE instances and in different versions that I monitor.</ase_name> I noticed that for monitored ASE 16.0 SP04 PL06 HF1 the 'procedures used' is 'sp_sysmon_xxx_V16'...

ok, JP. thank you, I will give ot a try with shorter deleteSleep

Thank you. And I suppose there is no way to increase the packet size of these 1000 rows?

Hello JP, so, I restarted the logger with flag 113 and the Purge task works indeed, but apparently it's very slow as it deletes 1000 rows at a time every 100 ms as per the attached ss with logs. It started with the biggest table for the monitored instance, XXX_OpObjAct. It's over 71 GB in size and has over 220 000 000 rows and there are over 40 000 000 rows with Timestamp < '2025/08/08 15:40:03' that are to be deleted as per daysToKeep=31 Is there a way to speed up this purging, e.g. deleting the...