Select to view content in your preferred language

Managing Direct Connections (kill and suspend)

6765
10
10-14-2010 06:58 AM
MichaelParma1
Deactivated User
ESRI has increasingly pointed users to leverage direct connects to SDE instead of application connections. We have followed this model and overall performance of our system is good. However, I have more and more often run into problems with users locking feature classes which we need to perform maintenance on.

I'm looking for a method to kill all user direct connections and suspend any new connections during the maintenance window. "sdemon -o kill ..." and "sdemon -o pause ..." don't work on the direct connects. Anyone have a suggestion or better yet, code examples?

Thanks,
Mike Parma
GIS Coordinator, City of New Braunfels
0 Kudos
10 Replies
StephenSanford
Deactivated User

arcpy.DisconnectUser("Database Connections\blahblablah.sde", "ALL")

ArcGIS Help (10.2, 10.2.1, and 10.2.2) 

0 Kudos