SQL queries monitoring through Gafana???

[Athanasios-Marios Ntouzidis]

Good evening. Is there a way to monitor the sql queries through the web-based UI of Grafana (like i am already doing with http, cpu, memory, etc). Right now they get monitored only through the InspectIT Analysis UI.

[Ivan Senic]

.Hi,

If you are interested in general SQL monitoring (statistics not divided based on the SQL query string), you can do this. The way is to add a Timer sensor with option charting=true to the method java.sql.Statement.executeQuery (and other methods of Statment class if needed). This way you can get information on the count and min/max/avg duration of this method execution, which in fact shows statistics on general SQL execution invoked from your app. You can see the example of this here: https://github.com/inspectit-labs/spring-petclinic-microservices/blob/inspectit/inspectit/petclinic_instrumentation_config.xml (profile  Petclinit [sql monitoring], lines 31-35).

Hope this was helpful.

Cheers,

Ivan

On Tue, May 15, 2018 at 4:21 PM, Athanasios-Marios Ntouzidis <thanosn...@gmail.com> wrote:

Good evening. Is there a way to monitor the sql queries through the web-based UI of Grafana (like i am already doing with http, cpu, memory, etc). Right now they get monitored only through the InspectIT Analysis UI.

--
You received this message because you are subscribed to the Google Groups "inspectIT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to inspectit+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/inspectit/9e7fe912-0b97-49f4-a066-534353df3700%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Ivan Senić
senic...@gmail.com
+381 65 5365272