I'd like to edit Deadlock rule to add severity per victimLostTime range. For example, if sum of "victimLostTime" is greater than 10 sec, then its a WARNING, and greater than 60 sec, then CRITICAL, etc..
The idea of "victimLostTime" actually comes from DBSS - Deadlock Details rule. The time variable is used in an alarm message in it.
So I tried to read the "victimLostTime" in DBSS - Deadlocks rule, but failed to get it.
Can you guys give me an advice how to get it?
Thanks in advance.
My environment is Foglight 5.9.5, + SQL Server cartridge.