Steve Knell

Hi J-P We are being asked to add authentication to the Asemon reporter website - we are using PHP-FPM on the back-end. Is there any simple way to do that, please? Or any docs which might help us? OpenID is the preferred route here. Thanks, Steve

Hi J-P, The IQctx table has only 1024 chars for the CmdLine column, but I believe sp_iqcontext returns 4096 chars? We tried to extend the column datatype to 4096, but still only the first 1024 chars of the command are captured? Is a change required in the Java code to get the full 4096 chars? Thanks, Steve

Hi J-P - quick question - I don't see any IQ collector that runs "sp_iqlocks". Is that because this is rarely useful for IQ? (we use sp_lock in ASE a lot)

Is the IQ sysmon collector safe to run in Production? Any likely % performance impact? Should any groups be disabled in Prod (if that's something that is configurable)?

Hi J-P - Does your IQ sysmon collector include any spinlock information?

Hi J-P - also do you use sa_locks() at all, in any of your collectors?

Hi J-P, The CPU/Requests collector is running every 30s. The plots looks fine when all the samples are present. However, if the system is running very slowly and the samples get delayed, I'm seeing big gaps in the plot during that period. When I mouseOver I can see some samples in the gap but nothing is being plotted? see attached Thanks, Steve

HI J-P, Thanks for that, I'll give it a try. One more question (sorry!) - is it possible to get CPU figures per connection using Asemon 3.2.3 (or at all in any of the IQ monitoring tables?). Or a CPU figure per context or statement? Thanks again, Steve