title: how to find all the sleeping sessions which are created for DQL commands in SQL Server
body: <p>Actually, I would like to kill some sessions in SQL Server which are sleeping for so long. But, I got a doubt that if we kill any sleeping session which is having DML commmands, it may rollback the transaction and probably cause some other issues. So, I want to kill only those sessions which are created for select queries. Is there any way that I can find those sessions which are having only DQL commands.</p>