KILLING spids Automatically
Posted on 2009-05-18
My company has recently adopted a policy where idle Citrix connection are terminated during the middle of the night. Most of these disconnected sessions have been using an application based on SQL Server, and the SQL Server connection persists after the Citrix connection has been dropped.
I have been researching the periodic removal of idle processes in SQL, using KILL spid. I have read that processes with a cmd of 'AWAITING COMMAND' should NOT be killed. However, I have never found anything which actually says WHY they shouldnt be killled, or the dangers...
As the user has been diconnected, these processes are orphaned. Is there any functionality in SQL server to drop idle connections? Is it really naughty to KILL these orphaned spids?