topic Re: Identifying open edit sessions in SDE in ArcGIS Enterprise Questions

Identifying open edit sessions in SDE

LinkElmore — Wed, 15 Feb 2017 17:30:18 GMT

I am interested in learning a method to identify open edit sessions for users connected to a SQL/SDE database. Using SQL Management Studio, it is possible to examine the sde_object_locks table. However, I am unsure if this reflects merely a lock from a user with edit privileges who is connected to their version or if it additionally means they are in an active edit session. My interest is in being able to disconnect users to perform db maintenance without risking the possibility of data loss if they are in an active edit session.

Re: Identifying open edit sessions in SDE

LinkElmore — Wed, 15 Feb 2017 19:45:47 GMT

I answered my own question by having a user open and close an edit session while refreshing the SQL query to view sde_object_locks. Whenever an edit session opened, a new record appeared. Closing the edit session removed the record from the table. By cross referencing the object_id field with the version_id field in the sde_versions table, it's possible to see which version is locking the database. Since each of my users has their own version, I know who to contact to disconnect before running maintenance operations that require disconnection.

Re: Identifying open edit sessions in SDE

Asrujit_SenGupta — Thu, 16 Feb 2017 05:22:55 GMT

Take a look at the SDE_states table as well. Whenever an user will be in an editing session, there should be an open state present in that table. Its easy to identify the user from there as well.