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

[sharjeelb]

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.

[AntonPineiro]

Hi,

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

Are you in Grail?

Best regards

[sharjeelb]

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"

[AntonPineiro]

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

[sharjeelb]

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")

[AntonPineiro]

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

[AntonPineiro · Accepted solution]

Product idea has been raised -> https://community.dynatrace.com/t5/Product-ideas/SQL-Deadlock-alerts-on-quot-database-quot-level-ins...