dead locks

• ramana3327

  SSCoach

  Points: 19722

  More actions

  April 17, 2015 at 4:08 pm

  #299917

  Hi,

  I am working with deadlocks.

  In my current environment, we have around 330 GB database. We are using Sql server 2008 r2 standard edition. We are seeing frequently deadlocks.

  Is there solution how to solve this kind of dead locks?

• Matan_Yungman

  SSC Eights!

  Points: 906

  More actions

  April 18, 2015 at 1:00 am

  #1791797

  You need to start by identifying in what parts of the code the deadlocks happen, and start analyzing why they happen.

  Here is a good resource for a start:

  [/url]

  You can also query the system_helath Extended Events session to get the information.