How to identify DB Locks on Dynatrace?

[miguel_balsa]

Hi,

A customer just asked me if there is anyway to identify DB locks on Dynatrace.

Is this possible?

Thanks!

[steven_ortega · Accepted solution]

Hey @Miguel Xoel Garcia B.,

I haven't found a specific way to monitor a DB lock without some digging but under Settings>Anomaly Detection >Infrastructure, you can set up a custom detection rule and have it set to "write time exceeding" which could help to identify a database lock. The same option exists for read time.

Also, in Settings>Anomaly Detection>Database services you can set response time degradation for services which could help point to database locks. Hope that helps!