SQL Server table keeps locking on inserts & updates, has around 60k rows and 130 columns (55 are computed). What to do to solve this problem? [closed]

rseugnpd 于 2023-08-02 发布在 SQL Server

关注(0)|答案(1)|浏览(101)

Closed. This question needs to be more focused . It is not currently accepting answers.

Want to improve this question? Update the question so it focuses on one problem only by editing this post .

Closed 16 days ago.
Improve this question

The table is used very frequently for read operations but due to it being updated every 5 minutes it keeps locking up off and on.

Are there any alternative strategies or databases that can be used to solve the read locking issues?

sql-server

来源：https://stackoverflow.com/questions/76697525/sql-server-table-keeps-locking-on-inserts-updates-has-around-60k-rows-and-130

1条答案

按热度按时间

gzjq41n41#

Read the table with a row-versioning isolation level to prevent writers from blocking readers, or readers from blocking writers. See Transaction locking and row versioning guide .

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server table keeps locking on inserts & updates, has around 60k rows and 130 columns (55 are computed). What to do to solve this problem? [closed]

1条答案

相关问题

热门标签

最新问答