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 | "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 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

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 | "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 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

KeithTubbs · ‎08-04-2022

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