I have table in SQL Server 2014. Please find the structure below:
We currently have around 8 systems that are running dotnet mvc applications that concurrently access the same database/same table for read/write. The issue is that, we very frequently get the above exception -- "Transaction was deadlocked on lock resources with another process and was chosen as the...". Could you please suggest what can be done to solve this issue or work around this issue? Maybe table restructuring, something at the sql server level? Any help will be greatly appreciated.