https://community.dynatrace.com/t5/Extensions/Using-Generic-Database-Query-Plugin-with-multiple-Databases-and/m-p/209441#M2945 <P>Hi!</P> <P>We are using Generic DB Query Plugin and its behavior is strange - it is not working according to the documentation and configuration settings.</P> <P>While there was just one endpoint and one query, everything worked as expected. There was one metric, and we customized the metadata for it - pretty name, units (seconds), dimensions, panels, and alerting.</P> <P>Then, we created one more endpoint, that is completely different - it is gathering data from another database, with different metrics, dimensions, etc. Data is ingested correctly (based on the logs), but everything from all the queries is now mixed within that first metric created. Ie no new metrics are created from the value columns, all that is gathered is added to the first metric, and it is a mess.</P> <P>Plugin documentation states that different metrics will be created. When I reached the Dynatrace team, they explained that the plugin could (for some reason) create only one metric and we are expected to differentiate by splitting. But how do we use different unit types (seconds, count, etc.) if this is a single metric? Alerting also works strangely as it triggers on data coming from various queries.</P> <P>Does anybody have experience of using the DB Query Plugin with multiple databases and queries? How do we split the feeds into different metrics? Or is there an alternative to this plugin?</P> <P>Thank you!</P> Tue, 20 Aug 2024 10:46:43 GMT alter 2024-08-20T10:46:43Z https://community.dynatrace.com/t5/Extensions/Using-Generic-Database-Query-Plugin-with-multiple-Databases-and/m-p/209441#M2945 <P>Hi!</P> <P>We are using Generic DB Query Plugin and its behavior is strange - it is not working according to the documentation and configuration settings.</P> <P>While there was just one endpoint and one query, everything worked as expected. There was one metric, and we customized the metadata for it - pretty name, units (seconds), dimensions, panels, and alerting.</P> <P>Then, we created one more endpoint, that is completely different - it is gathering data from another database, with different metrics, dimensions, etc. Data is ingested correctly (based on the logs), but everything from all the queries is now mixed within that first metric created. Ie no new metrics are created from the value columns, all that is gathered is added to the first metric, and it is a mess.</P> <P>Plugin documentation states that different metrics will be created. When I reached the Dynatrace team, they explained that the plugin could (for some reason) create only one metric and we are expected to differentiate by splitting. But how do we use different unit types (seconds, count, etc.) if this is a single metric? Alerting also works strangely as it triggers on data coming from various queries.</P> <P>Does anybody have experience of using the DB Query Plugin with multiple databases and queries? How do we split the feeds into different metrics? Or is there an alternative to this plugin?</P> <P>Thank you!</P> Tue, 20 Aug 2024 10:46:43 GMT https://community.dynatrace.com/t5/Extensions/Using-Generic-Database-Query-Plugin-with-multiple-Databases-and/m-p/209441#M2945 alter 2024-08-20T10:46:43Z https://community.dynatrace.com/t5/Extensions/Using-Generic-Database-Query-Plugin-with-multiple-Databases-and/m-p/214469#M3082 <P>We have a 1 to 1 ratio - 1 query for 1 server as 1 Generic DB Extension Endpoint. We have not run into any issues.</P> Thu, 08 Jun 2023 15:18:36 GMT https://community.dynatrace.com/t5/Extensions/Using-Generic-Database-Query-Plugin-with-multiple-Databases-and/m-p/214469#M3082 ChadTurner 2023-06-08T15:18:36Z https://community.dynatrace.com/t5/Extensions/Using-Generic-Database-Query-Plugin-with-multiple-Databases-and/m-p/222800#M3378 <P>Yes i agree. Everything is stored in custom.db.query metric but&nbsp;so it's quite difficult to manage it (filtering to select data for many dashboards).</P> Tue, 12 Sep 2023 10:03:20 GMT https://community.dynatrace.com/t5/Extensions/Using-Generic-Database-Query-Plugin-with-multiple-Databases-and/m-p/222800#M3378 rsaliou 2023-09-12T10:03:20Z