多线程批量更新数据库死锁问题？ - V2EX

Home Sign Up Sign In

This topic created in 2206 days ago, the information mentioned may be changed or developed.

在多线程场景下，对数据库的 merge 操作，会出现 sql server 死锁问题。请问大佬一般怎么解决？

1 replies • 2021-08-26 21:08:44 +08:00

1

mmdsun

Aug 26, 2021 via Android

MERGE 的并发注意事项：
https://docs.microsoft.com/zh-cn/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver15#concurrency-considerations-for-merge

分析死锁原因：
https://docs.microsoft.com/zh-cn/sql/tools/sql-server-profiler/analyze-deadlocks-with-sql-server-profiler?view=sql-server-ver15

About · Help · Advertise · Blog · API · FAQ · Solana · 3181 Online Highest 6679 ·

Select Language

创意工作者们的社区

World is powered by solitude

VERSION: 3.9.8.5 · 24ms · UTC 03:06 · PVG 11:06 · LAX 20:06 · JFK 23:06
♥ Do have faith in what you're doing.