Long Running Deadlock/SQL Query

I see Foglight has a rule by default named Long Running Job (SQL Server)

I would like to know if there is a Rule/Alarm to check any long running deadlock

or long running SQL query. If so, how can I enable them ?

If not so, How  I can create them?

The idea of long running deadlock/SQL query is to find out the existence of a deadlock/sql query  that is taking too much time to process

Thanks in Advance for your kind reply

Parents Reply Children
No Data