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

• Anonymous
  March 15, 2016
  Will it show all the text or will it truncate like dbcc inputbuffer does?

• Anonymous
  March 15, 2016
  It will show all the text as we changed the datatype to nvarchar(max).