SOLVED

how to change the inputbuf size for the deadlock.

Copper Contributor

I generate the deadlocks with long text sql, more than 2K, but when read the XDL file, I can not get the full SQL text, is there any parameter to change the SQL size for deadlock ? 

3 Replies

@AMarimuthu , Thank you for Ur update, 

BTW when I checked the system_health report , I got the same result , the deadlock graph XML can not keep all the SQL text.  just keep about 1K size text. 

also checked the SQL text with SQL handler,  in this way , I can get all the SQL text, but this is hard to make the mapping.

In the deadlock graph I got following , but there did exist some where options.

BEGIN TRANSACTION
UPDATE DlTable2 SET DL2Name = '111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111

best response confirmed by little_rat (Copper Contributor)
1 best response

Accepted Solutions
best response confirmed by little_rat (Copper Contributor)