scorpteq

The "broken" alert was because this article once instructed to make a multiple numeric return alert, but the query only returns a single value. So they corrected this page on June 11. Meanwhile, from my experience with the metric, I added notes on that article for my observations on how it works, and how to interpret the…

The resulting metric graph is actually useful if you keep in mind that the count is for a rolling window of about six to eight hours. The window size seems to vary among instances. So now I set the metric's Display Name back to just "Deadlocks" and the Description to "Total number of deadlocks in the last 6 hours or so.…

The query does sense deadlocks, but seems to be a count of deadlocks over the last six hours, and only decreases if there have been no more deadlocks for six hours. At least that's how it acts on our instances. So I set the metric's Display Name to "Deadlocks (in 6 hours)" and Description to "Total deadlocks in the last 6…