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

Home Sign Up Sign In

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

Sign Up Now

For Existing Member Sign In

This topic created in 2151 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 · 1111 Online Highest 6679 ·

Select Language

创意工作者们的社区

World is powered by solitude

VERSION: 3.9.8.5 · 32ms · UTC 17:32 · PVG 01:32 · LAX 10:32 · JFK 13:32
♥ Do have faith in what you're doing.