Deadlock on SDE MS SQL Server - ESRI 10.9.1

KeithTubbs · ‎08-04-2022

I'm having a problem with deadlock error code 17000, and with the following

"Error: DBMS deadlock victim [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Transaction (Process..."

I found a thread from 2014 where this was a continual problem, but not sure, if that information is relevant. Any help would be appreciated.

MarceloMarques · ‎08-04-2022

Read my Geodatabase Connections Best Practices Article in the link below, it talks about deadlocks and how to resolve the problem.
Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "About: In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 33 years, my passion for Spatial Databases and GIS data has become a central part of my career.." | “ The mountains are calling and I must go.” – John Muir |

View solution in original post

MarceloMarques · ‎08-04-2022

Read my Geodatabase Connections Best Practices Article in the link below, it talks about deadlocks and how to resolve the problem.
Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "About: In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 33 years, my passion for Spatial Databases and GIS data has become a central part of my career.." | “ The mountains are calling and I must go.” – John Muir |

KeithTubbs · ‎08-04-2022

Thanks for the response. I will go through this. I'm sure it will be helpful.