blockage SPID INFINITE

• abdalah.mehdoini

  Ten Centuries

  Points: 1012

  More actions

  June 9, 2022 at 12:04 pm

  #4046852

  hello ,

  is it normal to have this type of blockage?

  SPID 332 wait 358 and at the same time 358 wait for 332

  

  thanks

  • This topic was modified 2 years, 5 months ago by  abdalah.mehdoini.

• Alejandro Santana

  SSCommitted

  Points: 1838

  More actions

  June 9, 2022 at 1:37 pm

  #4046904

  Yes, that may turn out as a deadlock and SQL Server will kill one of the sessions so the other can finish.

   

  https://blog.quest.com/the-anatomy-of-sql-server-deadlocks-and-the-best-ways-to-avoid-them/