New DMF for retrieving input buffer in SQL Server
A new DMF for retrieving the input buffer for a session/request (sys.dm_exec_input_buffer) is now available in SQL Server 2016 RC0. This is functionally equivalent to DBCC INPUTBUFFER.
However, this has a few advantages over DBCC INPUTBUFFER.
- Directly returns a rowset.
- Can be conveniently used with sys.dm_exec_sessions or sys.dm_exec_requests by doing a CROSS APPLY.
- Can use a simple query to retrieve input buffer of multiple sessions without the need for a script and temp table.
For example:
Ajay Jagannathan ( @ajayMSFT)
Principal Program Manager