cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

Hi, Recently we experienced issue with DB performance. We found that some stored procedures and queries were running for more than 24 hours. Any way to monitor this situation. Means, how can I monitor SQL queries which are running for a long time. Thanks.

roushan_kumar
Inactive
 
1 REPLY 1

Babar_Qayyum
DynaMight Leader
DynaMight Leader

Hello Roushan,

Database Agent

This complements the fully integrated, application-related capturing of connection pool usage, SQL statements and transaction response time contribution,... that has been available for each and every DB call for a long time via JDBC, ADO.Net and PHP DB sensors in Java, .Net and PHP Agents respectively.

Check the following link for Database diagnostics use cases:

https://m.youtube.com/watch?v=pEXfqzE-WQM

Regards,

Babar