问题描述
目前我们在sql server 2014上面临死锁问题。
Currently we are facing deadlock issue on sql server 2014.
我们有一个存储过程，涉及表上的多次INSERTS（大约20个）以及执行时间这个存储过程 1:30秒我们已经通过死锁图和每个死锁报告声明这个存储的
过程导致死锁
we have one stored procedure which involves multiples INSERTS on tables(around 20) and time taking to execute this stored procedure s 1:30 secs . we have gone through deadlock graph and each and every dead lock report stating that this stored procedure causing the deadlock
我们如何重构这个存储过程而不会导致死锁。
how can we refactored this stored procedure without causing deadlock.
请建议在编写存储过程时遵循步骤以避免导致死锁。
please suggest the Steps need to be followed while writing a stored procedure to avoid causing the deadlocks.
推荐答案
我认为 您需要在插入一组数据之前专门锁定表格
I think you need to exclusively lock the table before insert a set of data
这篇关于在编写存储过程时需要遵循步骤以避免导致死锁的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！