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