TOP 50 SQL Queries by CPU/Memory/IO
Posted in 2019
Informix Version : 12XC12 Operating System : Linux Hi all I am looking for tools or script that can give the the top X queries that utilize the most 1) CPU 2) Memory 3) I/O on daily basis. Talking to a support engineer for advise, the only recommended tools is InformixHQ which only available in V14.00 or V12.XC14. I know I can download V14 and just extract few jar files but it was't recommended by the engineer that I working with since we are at V12.XC12 (upgrade is not an option now). InformixHQ only consist of some feature that we wanted and further customization is needed i.e. SQL script and etc. Questions 1) Is there a tool out there that can give me this quick win ? How about sentinel ? 2) Anyone have a customized script that can give us what we wanted? Any help is much appreciated. Thanks