topic Kill SDE connections using a batch file: in Data Management Questions

Kill SDE connections using a batch file:

JeremyRead — Thu, 10 May 2012 13:46:20 GMT

Does anyone have an example of how to kill specific SDE connections using a batch file? Basically, I manually kill certain connections throughout the day to keep our server from maxing out during peak hours.

The connections are searched by username: sdemon -o info -I users -i esri_sde2 | find "username"

Then killed: sdemon -o kill -i esri_sde2 -N -p password -t <S-ID>

I have used batch files for various things in the past, but this particular one is challenging. I was reading about using delimiters to find particular parts of a string, etc. and my head almost exploded. Does anyone have an example that I could use to get started?

Thanks 🙂

Re: Kill SDE connections using a batch file:

JakeSkinner — Fri, 11 May 2012 19:53:52 GMT

Hi Jeremy,

If you are running ArcSDE for SQL Server, you can try a python script I created. You can download it from here. I have not extensively tested it, so please let me know of any feedback.

Re: Kill SDE connections using a batch file:

JeremyRead — Fri, 11 May 2012 20:58:50 GMT

Hi Jake,

Thank you very much for the link! We are running Oracle here, but I will see if I can modify the script to work for us.

Cheers 🙂