AnsweredAssumed Answered

Delete records - database lock issue

Question asked by iamlaksh3 on Aug 12, 2015
Latest reply on Jul 14, 2016 by envs_sol

Hello All,

 

We are using ArcGIS GeoEvent manager 10.3.1 which gets input from GeoTab and collects data via feature service and store in SDE feature class. This is not versioned database. DBA folks alerting us particular delete record session takes more resource and results in LOCK.

 

SQL: DELETE FROM DATA.VEHICLES WHERE OBJECTID = 7155 consumes more resource in the database.

 

Please let me know if any one facing similar issue or any clue for this.

 

Outcomes