"MS SQL Expensive Query Plans" attribute group causing SQL Server agent collector to hang
Albook 120000625S Visits (3328)
Starting from SQL Server agent 6.31 FP11 (for APM v8.1.x infrastructure), a new attribute group is available: MS SQL Expensive Query Plans.
Anyway, on a small subset of SQL Server environments we observed it may cause delays or hangs on the ITCAM SQL Server agent collector.
The symptoms from user perspective looks like many other similar issues that occur at collection time : basically no one of the agent widgets
The failing agent does not send the expected metrics to APM because it does not receive data from the collector.
The collector basically invokes cursor KOQEXPQP
CTS0200T (2018-07-17 18:44:29) (18600)started collection for cursor KOQEXPQP
but this cursor never exits, never completes.
If this data set is not used, you can exclude it by re-configuring the agent from Template (right click Template entry-->Configure agent), select Edit for the failing instance and put the value KOQEXPQP in field "Extended Parms".
In this way the cursor is disabled and if there are no other cursors causing delays, you will see data in your APM dashboards for this SQL Server node.
If you instead needs data from attribute group "MS SQL Expensive Query Plans", I suggest you to open a case to IBM Support so that they can provide additional assistance to fix
Hope it helps.
Subscribe and follow us for all the latest information directly on your social feeds: