• Rule edit , DBSS - deadlocks, to add severity alarm per victimLostTime.

    Hello folks.

    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…

  • Deadlock investigation

    I recently wrote an inhouse document on how to use Foglight and trace Deadlocks. 

    Long story short, it appears that our Foglight isn't capturing all the deadlocks that are happening on our busiest production server.  I know this because a fellow DBA…