How to Create Deadlocks and Troubleshoot Them with sp_BlitzLock

Поділитися
Вставка
  • Опубліковано 6 лис 2024

КОМЕНТАРІ • 9

  • @chaitanya284
    @chaitanya284 2 місяці тому

    Hi brent. Thank you for insights. I am following you and eric since a while now. I saw your explanation in your video how to think like SQL server. It is helping me a lot in ny career and definitely many others like me. Keep up the good work. 😊

  • @ahmad-murery
    @ahmad-murery 5 років тому

    This is the most clearer explanation I read/watch about deadlock
    Thanks

  • @aler.4108
    @aler.4108 5 років тому +1

    Super, As always it is brilliant info, Brent! Many many thanks!

  • @bettylakew978
    @bettylakew978 5 років тому

    I am #1 fan of yours I read a lot of your blogs. I wanted to know if we can track every deadlock and blocking happening on production LIVE instead of 5sec threshold. Is that possible and how?

    • @TheBrentOzar
      @TheBrentOzar 5 років тому

      Thanks! Glad you like it. For questions, head to dba.stackexchange.com.

  • @curiousfreethinker8350
    @curiousfreethinker8350 3 роки тому

    well this is very useful indeed
    I just discovered your channel and blog and am already in love with ;-)
    I have a question though I saw a previous DBA using this report but couldn't find it in prod ? is it possible that you can run it without installing the whole Kit?
    Is it possible that it was uninstalled ?do we have to install it on the same production instance ? or we can run it from a different SQL server let's say on my laptop and run it against the prod?

    • @BrentOzarUnlimited
      @BrentOzarUnlimited  3 роки тому

      Many things are possible when you read the documentation. ;-)

    • @curiousfreethinker8350
      @curiousfreethinker8350 3 роки тому

      @@BrentOzarUnlimited Thanks I will definitely read, I just downloaded the kit, is everything regarding the kit in the readme document or there more detailed one to check ? I know I just started exploring and wanted to be on the right place to start