Sql-server – SQL Server process suspended while executing simple SQL (one row deletes and selects)

sql server

We have a problem on MS SQL Server. Processes get suspended. Looks like it is caused by simple SQL queries like Delete from x where id = @x, or select * from table where id = @x. Several similar parallel queries are being executed like delete one row. Process stays suspended. Any suggestions how to solve this problem?

More details about processes

In server reports no Locks or Blocks are reported. Process is suspending itself. There are no concurrent users or processes (it looks to me)

Best Answer

Today my colleague found "secret" article about Moodle configuration. Turns out we needed to set "Is Read Committed Snapshot On" to True. It solved the problem.