I have a C10 NT11 web app that acts as an API server with a MS SQL Server 2012 SP3 database. This web app receives requests from Android and iOS phones/tablets + Windows desktop C8 apps.
Every day the web app receives LOTS of ‘deadlocked on lock’ error messages, usually when trying to delete a record from the database. I think it is happening because the web app is receiving lots of requests to select and return data, while receiving requests to delete data from the same table. Here is an example of the deadlocked error message:
This is killing the web app when running as a service. Are there any MS SQL experts out there that can help with resolving this issue? The driver string I’m using for the database tables is:
/BUSYHANDLING=2 /MULTIPLEACTIVERESULTSETS=TRUE /ISOLATIONLEVEL=1 /BUSYRETRIES=5 /LOGONSCREEN=FALSE /VERIFYVIASELECT=TRUE /APPENDBUFFER=2000