Recently there's an open tran session that always hold tempdb log size till reach full in my SQL server. I did check on the SPID session but returns NULL value all the time. So what I do is just manually kill the SPID in order to release the tempdb log size.
Therefore, I would like to know if there any way on how I gonna setup an automate job/trigger to get kill that session (with NULL value) which holding the log size.
SQL Server Version : SQL 2014 Standard Edition
Thanks. Hope can get some idea in here. Appreciated.