Hi everyone. I have a 4-year-old system that is running SQL Server 2008 R2 on the backend and we are accessing the data through a MS Access front end. We are utilizing ODBC to connect to the server. I recently started receiving a TON of deadlock issues for my MS Access users and I really can't figure out why. I'm wondering if someone can point me in the right direction to figure out what is going on and how to solve it once and for all. It does not appear to be occurring on any one process or any smaller set of tables. It seems to occur across the broad spectrum of the whole database.
Wondering if its processing power or memory, or something. Restarting the server tends to make things work a little better, but the problems just keep coming back. The user experience on the front end is deadlocks when they're trying to read data and/or write data.
Any help someone can give would be awesome. I would think there is some way to log the deadlocks or something so I can see what the symptoms are surrounding their occurrence.
Thanks in advance!