Freigeben über

New DMF for retrieving input buffer in SQL Server

  • Artikel

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

Comments

  • 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).