Deadlock input buffer truncated

PeterDanielsCRB

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?

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

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.

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.