Deadlock input buffer truncated

I am using SQL Monitor 9.1.0.22802.  Monitoring a SQL Server 2014 SP2 instance (12.0.5000.0).  Seeing deadlock alerts.  When I go to view the SQL for the two sessions (victim and victor), the SQL is truncated (at 1024 chars).  Is this a limitation of SQL Monitor or maybe the underlying XE event?  Workaround?
Tagged:

Best Answers

  • Russell DRussell D Posts: 1,324 Diamond 5
    There is a limitation on the amount of xml data SQL Server can output from the extended events dmv, but it may also be an issue with Monitor. I will try and find out.
    Have you visited our Help Centre?
  • Russell DRussell D Posts: 1,324 Diamond 5
    Hi @PeterDanielsCRB , this appears to be an inherent limitation in extended events: we're not doing anything to truncate the query text.

    In the "output" panel on the alert, you should see the XML for the deadlock, and this includes the SQL handle for the query.  Assuming the query is still in the server's cache, it should be possible to query the server for it.
    Have you visited our Help Centre?

Answers

Sign In or Register to comment.