Timeline for Could concurrent user-triggered data fetches and inserts lead to deadlocks in a multi-user ASP.NET Core + MSSQL application?
Current License: CC BY-SA 4.0
Post Revisions
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 25, 2025 at 15:00 | comment | added | JimmyJames |
@freakish If I'm reading that right, it depends on the isolation level e.g. repeatable read.
|
|
| Mar 25, 2025 at 14:53 | comment | added | freakish | @JimmyJamessupportsCanada have a look here: stackoverflow.com/questions/57960609/… | |
| Mar 25, 2025 at 14:49 | comment | added | JimmyJames | @freakish If true, that's pretty sub-par. Do you have a reference for this behavior? | |
| Mar 25, 2025 at 12:45 | answer | added | Kain0_0 | timeline score: 1 | |
| Mar 24, 2025 at 15:22 | answer | added | Telastyn | timeline score: 1 | |
| Mar 23, 2025 at 9:44 | comment | added | freakish | In MSSQL big selects can and do lock entire table. | |
| Mar 22, 2025 at 7:36 | comment | added | Basilevs | What type of transactions is configured? | |
| Mar 21, 2025 at 21:21 | comment | added | JimmyJames |
I'm not very familiar with SQL Server, but it seems unlikely that reads would block writes unless you are using something like select for update. If you have high volume inserts, that can cause contention with a lot of indexing strategies. Without more info we can only guess.
|
|
| Mar 21, 2025 at 16:35 | comment | added | user1937198 | Its possible, but you really need the SQL Server wait data to do anything actionable that isn't as likely to cause more problems as fix it. The biggest thing you can do now is to put in systems to gather this data for when/if this happens again. | |
| Mar 21, 2025 at 16:04 | history | edited | Greg Burghardt | CC BY-SA 4.0 |
Code blocks are for code, not explanatory text.
|
| Mar 21, 2025 at 15:58 | review | Close votes | |||
| Mar 29, 2025 at 3:06 | |||||
| S Mar 21, 2025 at 15:09 | review | First questions | |||
| Mar 25, 2025 at 12:52 | |||||
| S Mar 21, 2025 at 15:09 | history | asked | ComfortableOnion | CC BY-SA 4.0 |