Missing parallel query management section for sp_sysmon

[elovelo]

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'

But for monitored ASE 16.0 SP02 PL07 it is 'local sp_sysmon procs'

I checked that in my archive database there are sysmon procedures pertaning to parallel query management:

sp_sysmon_parallel_PDO_V125
sp_sysmon_parallel_PDO_V150
sp_sysmon_parallel_PDO_V155
sp_sysmon_parallel_PDO_V157
sp_sysmon_parallel_PDO_V16
sp_sysmon_parallel_V125
sp_sysmon_parallel_V150
sp_sysmon_parallel_V155
sp_sysmon_parallel_V157
sp_sysmon_parallel_V16

Can you advise on this ? Thank you !

[Jean-Paul Martin]

Hi,
can you give me the result of this query :

select top 1 ASE_Version from XXXXXXX_SysMonFl2
where Timestamp = (select max(Timestamp) from XXXXXXX_SysMonFl2)

Replace XXXXXXX by the name of your V16SP02 monitored server

JP

[elovelo]

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.

[Jean-Paul Martin]

Are you sure, because this is not the version of a V16 SP02 PL07 server
This is the version of your ASE hosting the archive database

[Jean-Paul Martin]

are you sure that these two collectors are activated for your V16SP02PL07 servers ?

     <md> SysMon.xml                                     </md>
     <md> SysMonFld.xml                                  </md>