Deadlock input buffer truncated
PeterDanielsCRB
Posts: 126 Bronze 3
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 D Posts: 1,324 Diamond 5There 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 D Posts: 1,324 Diamond 5Hi @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