We have a lot of problems with hanging connection in ArcSDE. I try to remind users to disconnect from their SDE connections before closing ArcGIS, but sometimes they forget (and I do too sometimes). This causes hanging connections (phantom connections). Since our site license maxes out at 50 SDE connections (and hanging connections are counted), this is problem. I have a scheduled process setup to restart the ArcSDE service once a week, which remove these hanging connections. Unfortunately, a once a week restart may not be enough.
So the point of this post is that I want to be able to kill individual connections. We are supposed to be able to do this using the sdemon -o kill command. Unfortunately, whenever I try to do this, I get a message that says, "Operation failed, unable to kill server xxxx". So the kill command doesn't seem to work. Arg... Any suggestions or advice on why I can't kill single connections?
C:\Documents and Settings\ssnider>sdemon -o kill -t 7236 -s NDEP-24 -u SDE -p xxxxx -i 5151
ArcSDE Instance 5151 Process Management on NDEP-24 at Thu Jun 09 15:32:39 2011
-------------------------------------------------------------------------
Kill Server Task 7236? ARE YOU SURE (Y/N)?: y
Operation Failed, Unable to kill server 7236