SQL Server 2016: Script to find last statement executed by a SPID using sys.dm_exec_input_buffer

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In the previous post, I have shared important details about SQL Server DBCC INPUTBUFFER and how we can use it to find a lead blocker transaction.

SQL Server: DBCC INPUTBUFFER to find the last statement executed by a SPID

SQL Server 2016 introduced sys.dm_exec_input_buffer which is a extended version of DBCC INPUTBUFFER.
It is also serving the same service like DBCC INPUTBUFFER.

You can build your full query using this new system dmv.

Prepared a script to find the last statement executed by SPID.