How can we help you today? How can we help you today?

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?
Peter Daniels
0

Comments

3 comments

Sort by
  • Russell D
    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.
    Russell D
    0
  • Russell D
    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.
    Russell D
    0
  • PeterDanielsCRB
    Thanks, @Russell D . It would be cool if this was built into SQL Monitor, so we could just click into the full SQL + plan.
    PeterDanielsCRB
    0

Add comment

Please sign in to leave a comment.