When automating Enterprise GeoDB / SDE maintenance tasks, what are considerations regarding connected users?

374
1
10-16-2017 07:24 AM
PhilippConner1
New Contributor

I have been tasked with scripting maintenance tasks for enterprise GeoDBs / SDE. This included compression, statistics, and index rebuilds. Need I be concerned about connected users when performing these operations? There is little risk of users actually being on the Esri environment at the time of execution, as these will mostly run after hours. If a user is in an edit session / inserting, would this cause exceptions in the script or corrupt data? I know there is scripting support for checking connected users and disconnecting them, I just don't know if this is mandatory.

0 Kudos
1 Reply
DerekLaw
Esri Esteemed Contributor

Hi Philipp,

> There is little risk of users actually being on the Esri environment at the time of execution, as these will mostly run after hours.

This is a good practice. You typically do NOT want users connected to your enterprise geodatabase when performing any maintenance tasks.

Hope this helps,