Deadlock during Bulk operations

• nikhil.desai1

  SSCommitted

  Points: 1948

  More actions

  October 6, 2014 at 7:02 am

  #312034

  Hi,

  I am working on production environment of SQL Server 2012. .Net is used as front end apllication. Bulk operations are done via .net application i.e. fn_RegexMatch which calls external CLR. In short the bulk operations are done via .net coding which is hidden

  During bulk operations most of times deadlocks occurs. I have captured the deadlock in errorlog file As per analysis deadlock occurs when two different stored procedure are executed and both of them uses same table and same primary clustered index (cluster index on only one cloumn). Both spids are waiting for each other on same object using exclusive lock

  Also when I executed sp_lock I have observed lock type as HBT and Resource as BULK_OPERATION with mode as Shared and Status as Grant.

  Can you please suggest any other analysis I should do to overcome this type of deadlock because more than 50 deadlocks occurs during bulk operations

  Thanks and Regards,

  Nikhil P Desai

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 6, 2014 at 8:20 am

  #1750319

  nikhil.desai1 (10/6/2014)

  ---

  Hi,

  I am working on production environment of SQL Server 2012.

  So why post to the 2005 and 2008 forums?

  BTW, don't cross post to multiple forums, it just clutters replies.

  Replies here please: http://www.sqlservercentral.com/Forums/FindPost1623053.aspx

  -- Gianluca Sartori