Kill only old connections

[BrentHoskisson]

Is there a way to kill only the SDE connections that are over 24 hours old?

[JamesLandwehr]

Jake, does this mean that if we are using direct connects that your method of deleting old/orphan SID/SPID's at the SQL level is okay? We stop and restart our services every night and from what I can see of the processes, we have a bunch of orphans from yesterday out there in addition to the ones that started this morning. Will running this command clear those out? Thanks.

[BrentHoskisson]

Brent,

It looks like you are connecting to you SDE geodatabase using an ArcSDE service.  Have you considered using a direct connection?  This is usually the recommended way to connect an SDE geodatabase. 

This is an entirely different complaint.  But my users are only using ArcEngine Runtime.  Direct Connect doesn't work (apparently) except with ArcView or better.  So yes, I have tried it - doesn't work - oh well, I'm dealing with it.

[JakeSkinner · Accepted solution]

I would follow the KB article then, and set your TCPKEEPALIVE to TRUE.  Remember to restart the ArcSDE service for the changes to take affect.