Hello Community,
I am trying to find a way to monitor or check the amount of triggers the DB thing is creating and whether that is contributing to the performance of the ThingWorx due to load getting created on the SQL server from where I am getting data.
I am aware of the C3P0 thread count which can be used to monitor the DB connections, but that is specific to the default persistence provider.
I am fetching data from multiple DBs using MS SQL DB Thing connectors.
I want to know if there is any way we can monitor the queue size and active connections.
So, in the DB Thing Configuration tab, the JDBC connection settings has an option of Maximum Number of Connections which is set to 5 and there's also an option to enable monitoring. But I am trying to understand how I can do the monitoring even if it is enabled.
Also, how to monitor the active connections out of the maximum 5 and the requests or the queue size to the DB thing at a regular interval. Please refer to the below reference image to what I am trying to point.
In addition to above, can anyone point towards the Db connection limit(not specific to persistence provider), that is set or allowed between ThingWorx and any MS SQL server. Is this setting done at ThingWorx level or Tomcat or the JVM level and how can I verify the same.
NOTE: I am aware that all the SQL servers I'm using are under load, but I am trying to find which ThingWorx SQL services are creating the load.
