topic Re: SQL Deadlock alerts on "database" level instead of "Instance" level in Extensions

SQL Deadlock alerts on "database" level instead of "Instance" level

sharjeelb — Fri, 27 Feb 2026 07:32:22 GMT

We are currently getting the SQL related deadlock alerts on instance level, but we are looking to get these alerts on database level and looking to see if there's any solution available to achieve this goal.

Re: SQL Deadlock alerts on "database" level instead of "Instance" level

AntonPineiro — Thu, 26 Feb 2026 14:08:34 GMT

Hi,

If you create a metric event for that metric, can you select database entity in dimension?

Are you in Grail?

Best regards

Re: SQL Deadlock alerts on "database" level instead of "Instance" level

sharjeelb — Thu, 26 Feb 2026 14:54:14 GMT

I already tried but unfortunately there's no option for this! I'm seeing only two parameters to use either based on "SQL Server" or "SQL Instance"

Re: SQL Deadlock alerts on "database" level instead of "Instance" level

AntonPineiro — Thu, 26 Feb 2026 16:03:41 GMT

Hi,

If you are not using Managed, I recommend you using DQL and Anomaly detector app. Be sure your entity appears in data and fill property "dt.source_entity" with correct entity.

Which metric are you using? Is only available in instance level? Not equivalent in database level?

Best regards

Re: SQL Deadlock alerts on "database" level instead of "Instance" level

sharjeelb — Thu, 26 Feb 2026 18:20:54 GMT

This is the metric I'm using,

It's only available with server_instance or server itself but not on database level.

sql-server.locks.deadlocks.count:splitBy("dt.entity.sql:sql_server_instance")

Re: SQL Deadlock alerts on "database" level instead of "Instance" level

AntonPineiro — Fri, 27 Feb 2026 08:04:38 GMT

Hi,

That metric is only available in instance level, it means, all databases will have same deadlock value. If you still want that, you can create a product idea or create your custom anomaly detector using DQL, adding instance layer.

Best regards

Re: SQL Deadlock alerts on "database" level instead of "Instance" level

AntonPineiro — Mon, 02 Mar 2026 16:51:07 GMT

Product idea has been raised -> https://community.dynatrace.com/t5/Product-ideas/SQL-Deadlock-alerts-on-quot-database-quot-level-instead-of-quot/idi-p/295493