SQL Server 2016死锁 [英] SQL Server 2016 deadlock

问题描述

我有一个显示死锁的死锁图，但它没有告诉我哪些存储过程来自这些语句。如何查看导致死锁的存储过程？

解决方案

您是指使用扩展事件默认捕获的死锁图" xml_deadlock_report " ;?如果是这样，在XML报告中，查找
< executionStack> 和< inputbuf> ，您应该看到死锁中涉及的sprocs。 

I have a deadlock graph showing deadlock but it is not showing me which stored procedures are these statements from. How can I see the stored procedure causing the deadlock?

解决方案

Are you referring to the deadlock graph which is captured by default using the extended event "xml_deadlock_report"? If so, on the XML report, look for the <executionStack> and <inputbuf> you should see the sprocs involved in the deadlock. 

这篇关于SQL Server 2016死锁的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！