How to monitor IBM Websphere JMS / MQ / QCF Connection Pools?

[craig_b]

Hello!

We are looking for ways to monitor IBM Websphere JMS connection pools, and surprisingly I am not seeing where this is possible without doing something via the PMI extension which might be expensive in terms of DDUs. 

There are lots of built-in connection pool metrics in Dynatrace for Websphere, but they are all for Database connection pools (ie, builtin:tech.websphere.connectionPool.connectionPoolModule.PoolSize).  

Would love to hear what others are doing for this!

[AntonPineiro · Accepted solution]

Product idea has been raised -> https://community.dynatrace.com/t5/Product-ideas/Add-support-for-IBM-Websphere-JMS-MQ-connection-poo...

[gopher]

Hi @craig_b 
You can always do a custom JMX extension and just get the subset that you require. 
It will consume DDU, but not as much as getting all PMI. 

Extensions 2.0 concepts — Dynatrace Docs

e.g

{
  "version": "2.2",
  "name": "custom.jmx.WebSphere",
  "type": "PMI",
  "metricGroup": "custom.jmx.WAS",
  "processTypes": [
    13
  ],
  "entity": "PROCESS_GROUP_INSTANCE",
  "configUI": {
    "displayName": "WAS"
  },
  "ui": {
    "charts": [
      {
        "group": "WAS metrics",
        "title": "threadPoolModule ActiveCount",
        "series": [
          {
            "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_6f8e_1563942805350",
            "aggregation": "max",
            "displayname": "threadPoolModule: ActiveCount"
          }
        ]
      },
      {
        "group": "WAS metrics",
        "title": "threadPoolModule PercentUsed",
        "series": [
          {
            "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_7115_1563942869581",
            "aggregation": "max",
            "displayname": "threadPoolModule: PercentUsed"
          }
        ]
      },
      {
        "group": "WAS metrics",
        "title": "threadPoolModule DeclaredThreadHungCount",
        "series": [
          {
            "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_2cbd5_1564230569509",
            "aggregation": "max",
            "displayname": "threadPoolModule: DeclaredThreadHungCount"
          }
        ]
      },
      {
        "group": "WAS metrics",
        "title": "connectionPoolModule PercentUsed",
        "series": [
          {
            "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_75ee_1563943173210",
            "aggregation": "max",
            "displayname": "connectionPoolModule: PercentUsed"
          }
        ]
      },
      {
        "group": "WAS metrics",
        "title": "connectionPoolModule WaitingThreadCount",
        "series": [
          {
            "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_7832_1563943298163",
            "aggregation": "max",
            "displayname": "connectionPoolModule: WaitingThreadCount"
          }
        ]
      },
      {
        "group": "WAS metrics",
        "title": "connectionPoolModule WaitTime",
        "series": [
          {
            "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_afd_1563943553872",
            "aggregation": "max",
            "displayname": "connectionPoolModule: WaitTime"
          }
        ]
      },
      {
        "group": "WAS metrics",
        "title": "servletSessionsModule ActiveCount",
        "series": [
          {
            "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_2621_1563943722733",
            "aggregation": "max",
            "displayname": "servletSessionsModule: ActiveCount"
          }
        ]
      },
      {
        "group": "WAS metrics",
        "title": "servletSessionsModule LiveCount",
        "series": [
          {
            "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_c0c_1563943812604",
            "aggregation": "max",
            "displayname": "servletSessionsModule: LiveCount"
          }
        ]
      }
    ]
  },
  "metrics": [
    {
      "timeseries": {
        "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_6f8e_1563942805350",
        "unit": "Count",
        "displayname": "threadPoolModule: ActiveCount",
        "dimensions": [
          "rx_pid"
        ]
      }
    },
    {
      "timeseries": {
        "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_2cbd5_1564230569509",
        "unit": "Count",
        "displayname": "threadPoolModule: DeclaredThreadHungCount",
        "dimensions": [
          "rx_pid"
        ]
      }
    },
    {
      "timeseries": {
        "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_7115_1563942869581",
        "unit": "Percent",
        "displayname": "threadPoolModule: PercentUsed",
        "dimensions": [
          "rx_pid"
        ]
      }
    },
    {
      "timeseries": {
        "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_75ee_1563943173210",
        "unit": "Percent",
        "displayname": "connectionPoolModule: PercentUsed",
        "dimensions": [
          "rx_pid"
        ]
      }
    },
    {
      "timeseries": {
        "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_7832_1563943298163",
        "unit": "Count",
        "displayname": "connectionPoolModule: WaitingThreadCount",
        "dimensions": [
          "rx_pid"
        ]
      }
    },
    {
      "timeseries": {
        "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_afd_1563943553872",
        "unit": "MilliSecond",
        "displayname": "connectionPoolModule: WaitTime",
        "dimensions": [
          "rx_pid"
        ]
      }
    },
    {
      "timeseries": {
        "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_2621_1563943722733",
        "unit": "Count",
        "displayname": "servletSessionsModule: ActiveCount",
        "dimensions": [
          "rx_pid"
        ]
      }
    },
    {
      "timeseries": {
        "key": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_c0c_1563943812604",
        "unit": "Count",
        "displayname": "servletSessionsModule: LiveCount",
        "dimensions": [
          "rx_pid"
        ]
      }
    }
  ],
  "source": {
    "subscriptions": [
      {
        "modulepath": [
          "threadPoolModule",
          "AriesThreadPool"
        ],
        "statistics": [
          {
            "timeseriesKey": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_6f8e_1563942805350",
            "statisticName": "ActiveCount",
            "statisticType": "BoundedRangeStatistic",
            "valueName": "Current",
            "calculateDelta": false,
            "calculateRate": false,
            "aggregation": "MAX"
          }
        ]
      },
      {
        "modulepath": [
          "threadPoolModule"
        ],
        "statistics": [
          {
            "timeseriesKey": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_7115_1563942869581",
            "statisticName": "PercentUsed",
            "statisticType": "BoundedRangeStatistic",
            "valueName": "Current",
            "calculateDelta": false,
            "calculateRate": false,
            "aggregation": "MAX"
          }
        ]
      },
      {
        "modulepath": [
          "connectionPoolModule"
        ],
        "statistics": [
          {
            "timeseriesKey": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_75ee_1563943173210",
            "statisticName": "PercentUsed",
            "statisticType": "RangeStatistic",
            "valueName": "Current",
            "calculateDelta": false,
            "calculateRate": false,
            "aggregation": "MAX"
          }
        ]
      },
      {
        "modulepath": [
          "connectionPoolModule"
        ],
        "statistics": [
          {
            "timeseriesKey": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_7832_1563943298163",
            "statisticName": "WaitingThreadCount",
            "statisticType": "RangeStatistic",
            "valueName": "Current",
            "calculateDelta": false,
            "calculateRate": false,
            "aggregation": "MAX"
          }
        ]
      },
      {
        "modulepath": [
          "connectionPoolModule"
        ],
        "statistics": [
          {
            "timeseriesKey": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_afd_1563943553872",
            "statisticName": "WaitTime",
            "statisticType": "TimeStatistic",
            "valueName": "MaxTime",
            "calculateDelta": false,
            "calculateRate": false,
            "aggregation": "MAX"
          }
        ]
      },
      {
        "modulepath": [
          "servletSessionsModule"
        ],
        "statistics": [
          {
            "timeseriesKey": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_2621_1563943722733",
            "statisticName": "ActiveCount",
            "statisticType": "RangeStatistic",
            "valueName": "Current",
            "calculateDelta": false,
            "calculateRate": false,
            "aggregation": "MAX"
          }
        ]
      },
      {
        "modulepath": [
          "servletSessionsModule"
        ],
        "statistics": [
          {
            "timeseriesKey": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_c0c_1563943812604",
            "statisticName": "LiveCount",
            "statisticType": "RangeStatistic",
            "valueName": "Current",
            "calculateDelta": false,
            "calculateRate": false,
            "aggregation": "MAX"
          }
        ]
      },
      {
        "modulepath": [
          "threadPoolModule"
        ],
        "statistics": [
          {
            "timeseriesKey": "metric_com_compuware_apm_webui_model_configuration_api_extensioncreator_pmi_PmiStatisticDataContainerAutoBean_2_2cbd5_1564230569509",
            "statisticName": "DeclaredThreadHungCount",
            "statisticType": "CountStatistic",
            "valueName": "Count",
            "calculateDelta": false,
            "calculateRate": false,
            "aggregation": "MAX"
          }
        ]
      },
      {
        "modulepath": [
          "threadPoolModule"
        ]
      }
    ]
  }
}