4

I want to create a alert rule if a query on my SQL database takes longer than XXX seconds.

enter image description here

In the create alert dialog i cannot select a signal named "Duration".

enter image description here

Can you suggest a solution how to create a alert for a query taking longer than X seconds?

Daniel
  • 9,491
  • 12
  • 50
  • 66
  • Maybe we can use Azure SQL Analytics, reder this [post](https://www.sqlshack.com/getting-started-with-azure-sql-analytics/). It supports Query duration statistics. – Joseph Xu Apr 19 '21 at 10:00
  • i was expecting something more standard than using a service to configure a service for a service? – Daniel Apr 19 '21 at 17:27
  • Hi @Daniel Kindly let me know if you need more information. – Joseph Xu Apr 26 '21 at 05:42
  • 1
    @JosephXu sorry for not responding. Currently i am evaluation your response. I will write a reply after i have solved it. Currently i need to order a "Azure SQL Analytics" resource which currently takes some time... – Daniel Apr 26 '21 at 07:06

0 Answers0